[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Creating Comma Delimited Strings for "WHERE IN" statements



George -
 
It's not that simple. I "simplified" the query for example purposes only. I'm 
gonna try some of the suggestions I've received so far and post my results.
 
Thanks,
Darrel

George Jansen <GJANSEN@aflcio.org> wrote:
Why not 

Begin-Select
b.NBR
FROM table_b
WHERE b.NBR IN
(SELECT a.nbr 
FROM table_a a)
End-Select

???

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users