INNER JOIN Foreign Key

[camdenite]

Hi,

 

I got this:

 

SELECT category_id, tite FROM blogb, blog_category INNER JOIN cat_title;

 

and this:

 

$query = "SELECT blog_id, date2, heading FROM blogb";

 

and somehow want to mix the two.

 

On the first I want to actually just grab the title from blog_category dependant on the category_id in blogb. And make this all into one query.

 

Thank you for any advice or please just point me in the right direction.

 

Cheers.

[fenway]

Don't mix the two... just use the first one -- but you're missing the JOIN condition!