Join Syntax PLSQL

Can someone give me JOIN syntax for the following ...

select a.cola, b.colb, c.colc
from atable a, btable b, ctable c
where a.date = b.date
and a.id = b.id
and a.code = c.code
and a.id = 'X'
iBincAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
They look properly joined to me.  There is nothing wrong with that style.

Are you asking for the ANSI join syntax?

If so try this:
select a.cola, b.colb, c.colc
from atable a
	join btable b on a.date = b.date and a.id = b.id
	join ctable c on a.code = c.code
where a.id = 'X' 

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.