Need help with multiple SQL tables (JOIN)

Hey,

I have this code:

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

I may have missed the point, but it looks like you might be wanting to use a UNION rather than a JOIN since you just want to query multiple tables rather than join anything together.

See http://dev.mysql.com/doc/refman/5.4/en/union.html

Aside: whether you know it or not, by separating the tables by commas as you have, you're already doing an INNER JOIN on those tables.

Originally Posted by Salathe I may have missed the point, but it looks like you might be wanting to use a UNION rather than a JOIN since you just want to query multiple tables rather than join anything together. See http://dev.mysql.com/doc/refman/5.4/en/union.html Aside: whether you know it or not, by separating the tables by commas as you have, you're already doing an INNER JOIN on those tables.

The URL you provided didn't work =/

Aside: I am? Because when I try using that query I get an error message saying:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\FTPROOT\KTD\sh09hf1763\www\webbapplikationer09\ lab4\lab.php on line 26

EDIT: I used UNION, which was ALOT easier to understand, and now it works perfectly