[thelist] sql statement
JACOBSON, EDDY E (PB)
ej6978 at sbc.com
Tue Mar 29 15:44:36 CST 2005
Try
Select t1.sid,t1.name,t1.abrv,t2.prodid
>From table1 t1, table2 t2
Where t1.sid = t2.sid ;
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Donnie Blaker
Sent: Tuesday, March 29, 2005 1:36 PM
To: thelist at lists.evolt.org
Subject: [thelist] sql statement
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 !
More information about the thelist
mailing list