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 =
and =
and a.code = c.code
and = 'X'
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 = and =
	join ctable c on a.code = c.code
where = 'X' 

Open in new window

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.