| Re: help with logic [message #373377] |
Fri, 13 April 2001 09:58  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
