Hi all,
I have a question about join or inner join; not sure in what way it should be used.
I now use 2 queries in 2 different databases (made in phpmyadmin).
SELECT `title` FROM `writers` WHERE id ='qwert58efedd1979f';
SELECT `name`, `lastname`, `str`, `nr`,` place` FROM `client` WHERE id ='qwert58efedd1979f';
I would like to make one mysql query and use join to search in 2 tables in 2 different databases.
Can anyone tell how mysql does this?