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