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 stackoverflow.com/questions/6559261/… — RL89
– RL89, Commented Sep 14, 2012 at 7: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
– Sathyajith Bhat, Commented Sep 14, 2012 at 7:58
can give the table structures? like using 'desc dept_master' command — dejjub-AIS
– dejjub-AIS, Commented Sep 14, 2012 at 10:56

dejjub-AIS · Accepted Answer · 2012-09-14 08:07:14Z

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, 2012 at 8:07

dejjub-AIS

1,5413 gold badges25 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vicky Over a year ago

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.

Vishwanath Dalvi Over a year ago

@Vikash do you whitespaces in comp_id?

Geordee Naliyath · Accepted Answer · 2012-09-14 10:35:21Z

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, 2012 at 10:35

Geordee Naliyath

1,85921 silver badges29 bronze badges

Collectives™ on Stack Overflow

How to use inner join in oracle 11g?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related