Board index » delphi » Query from query
Andy Neverowsk
![]() Delphi Developer |
Wed, 18 Jun 1902 08:00:00 GMT
Query from query
I have big enough query with UNIONs and agregatives.
And then I need to build query that use result of first one. But I can't use VIEW because UNIONs are illegal in VIEWs. I can't build one big query because UNIONs haven't a name and impossible to apply to fields names for joins. In Access it is possible create first SELECT Q1.f1, T1.* FROM QUERY1 Q1, Table1 T1 (But Delphi don't allow to query from query ;-( ) In DB2 it is possible to write: SELECT Q1.f1, T1.* FROM (SELECT ...) Q1, Table1 T1 (But IB don't allow to query from query ;-( ) Who know how to query from query on Delphi and |