SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Joining temporary table with existing table.

tbhluehornNov 14 2016 — edited Nov 14 2016

Good Afternoon, please help me build a query which uses joins and temporary tables.

select Field1,Field2,Field3,Field4,Field5 from

(select * from Table1

join Table2

on Table1.CFIELD=Table2.CFIELD)

where Field3 < Field2

I want to join the output of this to an existing table3 using FIELD 5. Please help me .

This post has been answered by unknown-7404 on Nov 14 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2016

Added on Nov 14 2016

4 comments

1,349 views