use an outer join On Mon, 26 Nov 2001, Robert Everland wrote:
> Here is what I am trying to do. I have a table that lists types of > stuff. In another table I refer to this stuff. So say one record will refer > to stuff 1. another to stuff 2, but maybe no stuff 3 > how would I make a query to show > > stuff 1 = 1 > stuff 2 = 1 > stuff 3 = 0 > > My brain isn't working anymore > > Robert Everland III > Dixon Ticonderoga > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
