Nested SQL queries
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:

