Hey,
I have this code:
PHP Code:
$sql = "SELECT * FROM debate, sports, culture, economy WHERE author LIKE '%Eva Svensson%'";
As you can see, I'm trying to search through all the four tables "debate, sports, culture, economy" for posts by the author Eva Svensson, and when found, I want to print the whole post (headline, text, author, date).
Now, I know my current SQL query does not work, so I've been reading up on the JOIN command, which I can't seem to understand. So my question is:
Could anyone who knows how to JOIN multiple tables help me write the SQL query I need?
Thanks alot,
Jakob