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!

Multiple queries SQL

712759Jan 15 2010 — edited Jan 15 2010

I am pretty new to this game. Can anyone help me with probably a very simple query.

I want to write a query which returns all rows from table 1, and also returns all rows from table 2, however there is no relationship between the tables. I want to view these in crystal reports, based upon their date field which I will also be recieving.

An example would be

SELECT * from tbl1

AND

SELECT * from tbl2

Any help would be really appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2010

Added on Jan 15 2010

5 comments

642 views