Nested SQL queries

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:
[476 byte] By [JAL] at [2007-11-18 2:57:11]
# 1 Re: Nested SQL queries
try use a alias for the nested query.
in ex.:
select * from AnotherQuery.sql as qry1...
danprinz at 2007-11-9 13:33:09 >