Home » SQL & PL/SQL » SQL & PL/SQL » Queryoutput from 2 tables
Queryoutput from 2 tables [message #211239] Wed, 27 December 2006 09:09 Go to next message
mats_95
Messages: 7
Registered: May 2006
Junior Member
I have 2 tables as attached in the attachement.

I want a join of these 2 tables.Please help to do this.
Thanks
  • Attachment: tables.txt
    (Size: 0.50KB, Downloaded 161 times)
Re: Queryoutput from 2 tables [message #211242 is a reply to message #211239] Wed, 27 December 2006 09:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You asked exactly the same question seven months ago; the only difference is "two" vs. "2".

You got two answers, but eventually never replied to any of them. I'd suggest you to check previous topic and try to solve this problem by yourself. Then come back and say what went wrong (if anything), which prevented you to get the solution.
Re: Queryoutput from 2 tables [message #211264 is a reply to message #211242] Wed, 27 December 2006 12:29 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Littlefoot wrote on Wed, 27 December 2006 10:32
You asked exactly the same question seven months ago; the only difference is "two" vs. "2".



Wow! What a memory.
Re: Queryoutput from 2 tables [message #211284 is a reply to message #211264] Wed, 27 December 2006 15:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ummm, correct words-of-astonishment should have been "Wow! What a show all messages by mats_95!" ./fa/1598/0/
Re: Queryoutput from 2 tables [message #211406 is a reply to message #211284] Thu, 28 December 2006 07:50 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
But did you do a show all messages because the question sounded familiar or do you generally do a show all messages?
Re: Queryoutput from 2 tables [message #211420 is a reply to message #211406] Thu, 28 December 2006 09:47 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
you guys Laughing
Re: Queryoutput from 2 tables [message #211422 is a reply to message #211420] Thu, 28 December 2006 09:51 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do I always view list of previous messages? Of course not! But, seeing that he/she joined in May and it is his/her 2nd post, I just checked what was the 1st question about. Well, it was about the same issue.

Did it sound familiar? Of course! There are at least 2-3 questions a week about how to join two tables Smile
Previous Topic: Cursor - character to number conversion error in params
Next Topic: need help on query
Goto Forum:
  


Current Time: Sun Dec 11 00:49:15 CST 2016

Total time taken to generate the page: 0.09894 seconds