Stefan,

and if you use this

SELECT * FROM T2 WHERE (FIELD1,FIELD2,FIELD3) IN (SELECT FIELD1,FIELD2,FIELD3 FROM T1);


best regards,
São

----- Original Message -----
From: koronkas
To: firebird-support@yahoogroups.com
Sent: Friday, November 21, 2003 8:52 AM
Subject: [firebird-support] select from select


Hello to everyone,

First of all, I am very delighted and impressed by Firebird.
However, I encountered an issue which I couldn't solve.
I need to do something like:

SELECT * FROM ( SELECT * FROM T1 ) T2;

(ok, this is a verry dummy sample, but basically this is what i need)
For example, in IBExpert I get "invalid token" for the second select.

The question is - am I missing something or this kind of construct is
not (yet) possible in Firebird? (I am using now 1.5RC7)


Kind regards,
Stefan Koronka






Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]