Home » SQL & PL/SQL » SQL & PL/SQL » Get data from Multiple Columns to one column
Get data from Multiple Columns to one column [message #303905] Mon, 03 March 2008 03:53 Go to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
Hi all
I have a problem in querring data from three tables here is my scenario
table 1 cost_abc,
table 2 cost_def,
table 3 cost_fgh
here the table 1 contains cost_id as primary key and its details like date and create id and stuff.If the cost_id is applicable to only specific locations it goes to table 3 or else it goes to table 2.i want to extract details for cost id in table 1 wihch is etither in table 2 or table 3 how do i go about my querry


Please help
Re: Get data from Multiple Columns to one column [message #303908 is a reply to message #303905] Mon, 03 March 2008 04:06 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
please post your tables description and your desire output with some test cases.

regards
Re: Get data from Multiple Columns to one column [message #303911 is a reply to message #303905] Mon, 03 March 2008 04:15 Go to previous message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is clearly stated in the forum description: "Newbies should not post to this forum!"
Expert notion is defined in the sticky: Not an EXPERT? Post in the NEWBIES forum, NOT here
Rules are described in: OraFAQ Forum Guide
Follow them.

Regards
Michel

[Updated on: Mon, 03 March 2008 04:16]

Report message to a moderator

Previous Topic: Find 3 most current dates
Next Topic: DBMS_SQL
Goto Forum:
  


Current Time: Thu Dec 08 06:00:08 CST 2016

Total time taken to generate the page: 0.07626 seconds