Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-00933

Status
Not open for further replies.

gizmo2

Programmer
Jun 13, 2005
2
NL
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top