SQL for Oracle
David,
with a brief look at your query:
The FROM statement appears to use many tables and there are not commas
after every table name.
Also, the wildcard character in Oracle is % and should be enclosed in
single quotes.
I don't have any OO4O code handy right now but I recall a syntax like:
sqlstr = "select * from emp, dept where emp.deptno = dept.deptno and
emp.ename like 'A%'"
Also, I see more than 3 tables in your FROM clause.
Is this helping any?
Kostis Vezerides
|