Home » RDBMS Server » Server Administration » Re: help with logic
Re: help with logic [message #373377] Fri, 13 April 2001 09:58 Go to next message
sandeep
Messages: 110
Registered: October 2000
Senior Member
i want the result to be a,c,c,d,e.
table 1 : a,b,c,c,c,d,e
table 2 : b,c

i know how do get a,b,c,d,e - union will do that.
but how do i get a,c,c,d,e ?

this is just an example.
Re: help with logic [message #373378 is a reply to message #373377] Fri, 13 April 2001 10:08 Go to previous messageGo to next message
badjuju
Messages: 4
Registered: April 2001
Junior Member
The problem with your question is you did not state which fields you want c,c from.
For tab1, if the fields are fld1...fld7
and tab2, fld1 and fld2

You also did not list what table you want the fields from. You need to be clear on the field names and which table you want each field from.
Re: help with logic [message #373379 is a reply to message #373377] Fri, 13 April 2001 10:08 Go to previous message
badjuju
Messages: 4
Registered: April 2001
Junior Member
The problem with your question is you did not state which fields you want c,c from.
For tab1, if the fields are fld1...fld7
and tab2, fld1 and fld2

You also did not list what table you want the fields from. You need to be clear on the field names and which table you want each field from.
Previous Topic: ORA-01031 when create a MV
Next Topic: Count broken down By month. URGENT!!!!!!!!!!!!!!!!!!!!!!!!!
Goto Forum:
  


Current Time: Mon Dec 23 10:02:31 CST 2024