Query from two tables

[Marc Canale]

I have two tables set up like so:

foo { id, subject, owner, queue }
bar { id, fooId, content }

foo's id equals bar's fooId.....

I want to do something like:

select f.id, f.subject, f.owner, b.content from foo as f, bar as b where f.id=b.fooId;

This is the problem: not every foo id exists in bar's fooId so its only returning results where foo's id is in bar's fooId.

I want it to return everything from foo and not only what it finds in bar with foo's id.

Hope that makes sense...... Thanks.



Edited 1 time(s). Last edit at 08/08/2007 03:32PM by Marc Canale.