OraFAQ Forum: SQL & PL/SQL » select from two tables

Home » SQL & PL/SQL » SQL & PL/SQL » select from two tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select from two tables [message #636695]

Thu, 30 April 2015 05:38

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Hi guys,
I have table

A 
name id
a  1
b  2 
table 
B
name id 
c  3
d  4

How can I create a select statement that give me the records of table A and table B?

[Updated on: Thu, 30 April 2015 05:44] by Moderator

Report message to a moderator

Re: select from two tables [message #636697 is a reply to message #636695]

Thu, 30 April 2015 05:44

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

select * from a,b

[Updated on: Thu, 30 April 2015 05:44]

Report message to a moderator

Re: select from two tables [message #636698 is a reply to message #636697]

Thu, 30 April 2015 05:51

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

I am afraid that is not how to do it

select * from a union all select * from b ;

Report message to a moderator

Re: select from two tables [message #636699 is a reply to message #636698]

Thu, 30 April 2015 06:00

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

So you must show your desired output.

Read How to post a test case.
Read How to ask questions.
Read the OraFAQ Forum Guide

[Updated on: Thu, 30 April 2015 06:02]

Report message to a moderator

Re: select from two tables [message #636702 is a reply to message #636699]

Thu, 30 April 2015 06:28

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... and feedback to and thank people who help you.

Report message to a moderator

Re: select from two tables [message #636716 is a reply to message #636698]

Thu, 30 April 2015 12:31

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

amjad_alahdal wrote on Thu, 30 April 2015 06:51

I am afraid that is not how to do it
select * from a union all select * from b ;

If you knew the answer, why did you ask?

Report message to a moderator

Re: select from two tables [message #664497 is a reply to message #636716]

Thu, 20 July 2017 05:48

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

I hadn't known the answer. I read and tried and it worked. Thank You for your reply.

Report message to a moderator

Previous Topic:	ORA-1555 during pl/sql pocedure
Next Topic:	xml question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 30 15:59:12 CDT 2026