Home » SQL & PL/SQL » SQL & PL/SQL » HOW TO PULL DATA FROM 2 TABLE
icon5.gif  HOW TO PULL DATA FROM 2 TABLE [message #199095] Fri, 20 October 2006 02:28 Go to next message
NGSOOKFONG
Messages: 16
Registered: August 2006
Junior Member

Dear sir,

How to pull data from 2 table. Pls refer to the below table.

Table1

partno price
A1 $10
A2 $20


Table2

partno price
B1 $11
B2 $20



Output


A1 $10
A2 $20
B1 $11
B2 $20


Please help to write the Sql scripts.

Thanks
Mabel ng
Re: HOW TO PULL DATA FROM 2 TABLE [message #199097 is a reply to message #199095] Fri, 20 October 2006 02:35 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SELECT * FROM table1
UNION
SELECT * FROM table2;
Previous Topic: MERGE with variables instead of table dat
Next Topic: Sending message to mobile phones from oracle
Goto Forum:
  


Current Time: Mon Dec 05 08:45:02 CST 2016

Total time taken to generate the page: 0.09912 seconds