Home » SQL & PL/SQL » SQL & PL/SQL » How to join two SQL queries (Oracle,PL SQL)
How to join two SQL queries [message #321108] Mon, 19 May 2008 02:00 Go to next message
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
I had written two queries namely q1 and q2, but i want the result where the 2 queries should be joined.

  • Attachment: Q1 & Q2.sql
    (Size: 1.68KB, Downloaded 186 times)
Re: How to join two SQL queries [message #321113 is a reply to message #321108] Mon, 19 May 2008 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Join or union?

Regards
Michel
Re: How to join two SQL queries [message #321120 is a reply to message #321108] Mon, 19 May 2008 02:40 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

u may use union all.. .
Re: How to join two SQL queries [message #321138 is a reply to message #321113] Mon, 19 May 2008 04:00 Go to previous messageGo to next message
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
shall i have to write just JOIN / UNION between the two queries. And whats the difference between JOIN and UNION.
Re: How to join two SQL queries [message #321140 is a reply to message #321138] Mon, 19 May 2008 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Joins
UNION

I think you should follow a SQL course, this is basic SQL.

Regards
Michel
Re: How to join two SQL queries [message #321144 is a reply to message #321140] Mon, 19 May 2008 04:20 Go to previous messageGo to next message
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
Sorry for taking your time. And thanks for your advice.
Re: How to join two SQL queries [message #321150 is a reply to message #321144] Mon, 19 May 2008 04:27 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't be sorry, if I didn't want to give you this time I would not answer.

Regards
Michel
Previous Topic: Fcopy operation cannot be performed
Next Topic: FORALL gets executed twice
Goto Forum:
  


Current Time: Fri Dec 09 11:56:38 CST 2016

Total time taken to generate the page: 0.06630 seconds