By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,494 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,494 IT Pros & Developers. It's quick & easy.

problem in join statement

P: 3
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
Oct 29 '07 #1
Share this Question
Share on Google+
4 Replies


amitpatel66
Expert 100+
P: 2,367
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??
Oct 29 '07 #2

debasisdas
Expert 5K+
P: 8,127
All the syntax or either access or SQL Server are not supported in Oracle.
Kindly post your code for reference of our experts.
Oct 29 '07 #3

P: 3
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?
Nov 1 '07 #4

amitpatel66
Expert 100+
P: 2,367
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.
Nov 1 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.