[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
- Subject: RE: [sqr-users] Creating Comma Delimited Strings for "WHERE IN" statements
- From: Darrel Scott <darrel_1977@yahoo.com>
- Date: Thu, 22 Jan 2004 12:50:17 -0800 (PST)
- In-reply-to: <s00fecf1.083@webmail.aflcio.org>
- List-id: This list is for discussion about the SQR database reporting language from Hyperion. <sqr-users.sqrug.org>
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