if you dont mind me asking, whats the difference between an inner and an outer >From: Ed McCarroll <Ed at ComSimplicity.com> >Reply-To: "thelist at lists.evolt.org" <thelist at lists.evolt.org> >To: "thelist at lists.evolt.org" <thelist at lists.evolt.org> >Subject: Re: [thelist] sql statement >Date: Tue, 29 Mar 2005 13:52:24 -0800 > >To list all size names for product 213: > > SELECT size.name > FROM size S > INNER JOIN prod_size PS > ON S.sid = PS.sid > WHERE PS.prodid = 213 > >or equivalent... > >-- >Ed McCarroll (310) 838-4330 >Ed at ComSimplicity.com http://www.ComSimplicity.com > > >Quoting Donnie Blaker <filterhead80 at hotmail.com>: > > > I have two tables. sizes and prod_size. > > > > size has sid, name, abrv > > prod_size has sid, prodid > > > > when I do this look up I would like in one query get the all the > > sizes for > > that product. normally I would do two queries but I dont think > > that is the > > correct way. > > > > does someone know what I would use? like left join or join or > > something > > like that > > > > thanks > > > > _________________________________________________________________ > > Express yourself instantly with MSN Messenger! Download today - > > it's FREE! > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > > -- > > > > * * Please support the community that supports you. * * > > http://evolt.org/help_support_evolt/ > > > > For unsubscribe and other options, including the Tip Harvester > > and archives of thelist go to: http://lists.evolt.org > > Workers of the Web, evolt ! > > >-- > >* * Please support the community that supports you. * * >http://evolt.org/help_support_evolt/ > >For unsubscribe and other options, including the Tip Harvester >and archives of thelist go to: http://lists.evolt.org >Workers of the Web, evolt ! _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/