Join sub queries in PL-SQL

Viewed 27

I know this is really basic, but I'm stuck. I'm unable to select specific columns from a join of sub queries. For example -

This works -

select * from
(subquery) x
left join
(subquery) y
on x.id = y.id

This also works -

select x.id from
(subquery) x
left join
(subquery) y
on x.id = y.id

This works as well -

select y.id from
(subquery) x
left join
(subquery) y
on x.id = y.id

This does NOT work -

select x.id, y.id from
(subquery) x
left join
(subquery) y
on x.id = y.id

What am I missing in the last query? Appreciate any help. Thanks!

0 Answers
Related