what is wrong in the sql

[vishal sood]

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

[Thomasps]

"JOIN" in Oracle 8 ????

[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.

[Thomasps]

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...