-
what is wrong in the sql
Following query running properly in windows os but giving error in linux os. The error message is
Ther version of Oracle is 8.
'Sql command not ended properly.'
select u.UWKZNO, u.UWKZNAME, d.AMOUNT, s.SUPPLIERNAME
from INVOICE i
join INVOICEDETAILS d on i.INVOICEID=d.INVOICEID
join UWKZ u on u.UWKZID=d.UWKZID
join SUPPLIER s on s.SUPPLIERID=i.SUPPLIERID
where i.SEASONID=1 and i.ENTRYMONTH=1 and u.WKZID=1
Thanks
vishal sood
OCP 8
-
"JOIN" in Oracle 8 ????
-
yes this may be the problem. Because on windows OS we r having Oracle 9i(9.2.0) and on Linux we r having oracle 8i.(8.1.7).
and on windows Os the same query is working fine.
vishal sood
OCP 8
-
Originally posted by vishal sood
yes this may be the problem. Because on windows OS we r having Oracle 9i(9.2.0) and on Linux we r having oracle 8i.(8.1.7).
and on windows Os the same query is working fine.
"JOIN" is avialable only in 9.x.x onwards...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|