SQL question

[JuanCarlos60]

Hi,

When i build a SQL code with ACCESS 2000 and pasted in Data Environment it works fine; but when the same SQL i buld in Data Environment it don't work the both codes are:

SQL BUILDED IN ACCESS (WORK FINE)

SELECT VTA005.FCOST, VTA005.FFECHA, VTA006.F1ARTI,
VTA006.F1TIPR, VTA001.MNOMBR
FROM (VTA006 INNER JOIN
VTA005 ON (VTA006.F1NRFA = VTA005.FNRFAC) AND
(VTA006.F1ANOMES = VTA005.FANOMES) AND
(VTA006.F1AGEN = VTA005.FAGENC) AND
(VTA006.F1COST = VTA005.FCOST) AND
(VTA006.F1EMP = VTA005.FEMP)) LEFT JOIN
VTA001 ON (VTA006.F1TIPR = VTA001.MTIPR) AND
(VTA006.F1ARTI = VTA001.MARTI)



SQL BUILDED IN DATA ENVIRONMENT (DONT WORK)

SELECT VTA005.FCOST, VTA005.FFECHA, VTA006.F1ARTI,
VTA006.F1TIPR, VTA001.MNOMBR
FROM VTA005, VTA006 LEFT OUTER JOIN
VTA001 ON VTA006.F1TIPR = VTA001.MTIPR AND
VTA006.F1ARTI = VTA001.MARTI
WHERE VTA006.F1NRFA = VTA005.FNRFAC AND
VTA006.F1ANOMES = VTA005.FANOMES AND
VTA006.F1AGEN = VTA005.FAGENC AND
VTA006.F1COST = VTA005.FCOST AND
VTA006.F1EMP = VTA005.FEMP


TIA

[Bill Crawley]

your data environment is missing the brackets.

Thx Bill;

but i'm using the SQL Generator of DataEnvironment

in the second statement there is WHERE clause

TIA