where we have to use ON clause and where we have to use USING clause in JOINS

where we have to use ON clause and where we have to use USING
clause in JOINS

Question Posted / karthik87m

2 Answers
3214 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

where we have to use ON clause and where we have to use USING clause in JOINS..

Answer / saiprasanna

in ansi style the join condn can be given bu using "ON-clause"
or by using "USING-clause".
"USING" clause can be used if common column name is same other
wise "ON" clause is used.
ex:-select e.ename,d.dname from emp e join dept d on e.deptno
=d.deptno;
select e.ename,d.dname from emp e join dept d using(deptno);

Is This Answer Correct ?

3 Yes

0 No

where we have to use ON clause and where we have to use USING clause in JOINS..

Answer / vipul.solanki

It gives same result.when colum name is same then we can use
Using clause

with use USING :

SELECT * FROM MENU_MASTER MM JOIN MENU_ROLE_METRIX MRM
USING(NMENUNO);

with use ON :

SELECT * FROM MENU_MASTER MM JOIN MENU_ROLE_METRIX MRM ON
MM.NMENUNO = MRM.NMENUNO;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer