Nested SQL queries

[JAL]

Hello Gurus,
I am currently bumping on a strange problem on a Paradox database :

The following query does not work :

SELECT * FROM AnotherQuery.sql WHERE Col3 = 10


where AnotherQuery.sql contains :

SELECT Col3 FROM Table1 T1
LEFT OUTER JOIN Table2 T2
ON ( T1.Col1 = T2.Col1 ) AND ( T1.Col2 = T2.Col2 )


whereas it works if I write all in one query.
Any idea on what is going on ?

:confused: :eek:

[danprinz]

try use a alias for the nested query.
in ex.:
select * from AnotherQuery.sql as qry1...