Hi,
I'm not familiar with the finer points of oracle but I am getting the following error :
ORA-00933: SQL command not properly ended
in the following sql statement:
select contsupp.*,contsupp_1.contsupref
from contsupp left join contsupp as contsupp_1 on contsupp.recid = contsupp_1.linkacct
where contsupp.accountno='99101853375(L$#% Ber' and contsupp.rectype='C'
It works fine with DBASE IV.
Any help would be much appreciated.
Regards
Gizmo2
I'm not familiar with the finer points of oracle but I am getting the following error :
ORA-00933: SQL command not properly ended
in the following sql statement:
select contsupp.*,contsupp_1.contsupref
from contsupp left join contsupp as contsupp_1 on contsupp.recid = contsupp_1.linkacct
where contsupp.accountno='99101853375(L$#% Ber' and contsupp.rectype='C'
It works fine with DBASE IV.
Any help would be much appreciated.
Regards
Gizmo2