[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