problem in join statement

[linendra]

Hi

i am using oracle 8i. when i execute the join statement i got the error message. at the same time when i execute the same code to sql server and ms access the code execute successfully. i am not a regular user of oracle. hance i thougth that the join statement for orcle might be different.

please help me to solve this problem

or provide me the sample of join statement which execute successfully on oracle 8i

[amitpatel66]

Hi

i am using oracle 8i. when i execute the join statement i got the error message. at the same time when i execute the same code to sql server and ms access the code execute successfully. i am not a regular user of oracle. hance i thougth that the join statement for orcle might be different.

please help me to solve this problem

or provide me the sample of join statement which execute successfully on oracle 8i

How can you expect us to provide you a solution without having a look at your code??
Can you post your code here for reference??

[debasisdas]

All the syntax or either access or SQL Server are not supported in Oracle.
Kindly post your code for reference of our experts.

[linendra]

How can you expect us to provide you a solution without having a look at your code??
Can you post your code here for reference??

here is sample code of join statement which does not execute on oracle and execute successfully on sql server or MS Access.

select customer.cust_name, department.dept_name from customer INNER join department on customer.cust_id = department.cust_id

where is the fault occure?

[amitpatel66]

here is sample code of join statement which does not execute on oracle and execute successfully on sql server or MS Access.

select customer.cust_name, department.dept_name from customer INNER join department on customer.cust_id = department.cust_id

where is the fault occure?

Please POST The error that it is displaying?
It is executing fine for me.