How to use inner join in oracle 11g?

Question

I am running my Oracle query here but it's not working but the same query is working in SQL Server

Here is my query:

SELECT d.dept_code,
       d.dept_name,
       d.dept_desc,
       e.comp_name
FROM   dept_master d
       inner join comp_master e
               ON d.comp_id = e.comp_id

where in dept_master.comp_id value is the same as in Dept_Master table.

can you please update your code like this http://stackoverflow.com/questions/6559261/left-outer-join-using-sign-in-oracle-11g — RL89, Sep 14 '12 at 07:54
if you're not getting any results then that means either you join condition is wrong or there are no records matching the join condition — Sathyajith Bhat, Sep 14 '12 at 07:58
can give the table structures? like using 'desc dept_master' command — dejjub-AIS, Sep 14 '12 at 10:56

score 1 · Answer 1 · answered Sep 14 '12 at 08:07

1

The reason you are not getting any result is mainly because of the data

do this check to see if data is available in the tables

select * from dept_master;
select * from comp_master;

and see if both tables have any matching rows, i.e.; at least 1 row has same comp_id in both tables

I hope you will find the answer after doing this exercise

answered Sep 14 '12 at 08:07

dejjub-AIS

1,501
2
24
50

sir data is there in both tables but when i am fetching comp_id then it's containing some space and through that i am not able to join the query. – Vikash Sep 14 '12 at 09:50
@Vikash do you whitespaces in comp_id? – Vishwanath Dalvi Sep 14 '12 at 10:39

score 1 · Answer 2 · answered Sep 14 '12 at 10:35

1

Is comp_id a character field? In that case define it as VARCHAR2 in Oracle. or try trim(d.comp_id) = trim(e.comp_id)

See a demonstration in SQL Fiddle.

answered Sep 14 '12 at 10:35

Geordee Naliyath

1,799
17
28

How to use inner join in oracle 11g?

2 Answers2