Hey,
Thanks for your help!
Your query works perfectly.

Thank you,
Niall

-----Original Message-----
From: Ali Karimi [mailto:a97alika@s...]
Sent: 11 July 2002 23:25
To: sql language
Subject: [sql_language] SV: SV: RE: This is IMPOSSIBLE!


OK :o)
I decided to NOT being so LAZY and actualy
construct the query and send it to you.


SELECT _ID, PROJECT, ROLE, DAYS
FROM TABLEA
UNION
SELECT _ID, PROJECT, ROLE, DAYS
FROM TABLEB
WHERE NOT EXISTS(SELECT PROJECT, ROLE
		 FROM TABLEA
		 WHERE TABLEA.PROJECT =3D TABLEB.PROJECT AND TABLEA.ROLE =3D
TABLEB.ROLE)


I hope that this is what you are looking for.


Regards
/ Ali Karimi





-----Ursprungligt meddelande-----
Fr=E5n: Ali Karimi [mailto:a97alika@s...]
Skickat: den 12 juli 2002 00:06
Till: sql language
=C4mne: [sql_language] SV: RE: This is IMPOSSIBLE!


Hmmm.. ok!
I did not understand the problem from the beginning.
If i DO understand it correctly now :o) then what about
using a nested select statements in the second query,
using NOT EXIST?

I think that would solve your problem!

Regards
/ Ali

-----Ursprungligt meddelande-----
Fr=E5n: Niall Hannon (ext. 772) [mailto:Niall.Hannon@f...]
Skickat: den 11 juli 2002 18:48
Till: sql language
=C4mne: [sql_language] RE: This is IMPOSSIBLE!


Hi,

But this cant work.

Lets say data in TableA Is

ID	Project	Role	Days
1	Rollout	DBA	2
2	Rollout	STA	3
3	Test		TTT	2

tableb

ID	Project	Role	Days
1	Rollout	DBA	2
3	Rollout	TTT	3
4	Test		TTT	2

Your Statement would return no records from TableB - it should bring 
Record
ID 3 from TableB. Because I need to compare Project AND Role per 
reocord.

-----Original Message-----
From: Denis Gobo [mailto:dgobo@w...]
Sent: 11 July 2002 17:41
To: sql language
Subject: [sql_language] RE: This is IMPOSSIBLE!



select DAYS
from TableB
where project not in(select project from TableA)
And	role not in(select role from TableA)

-----Original Message-----
From: Niall Hannon (ext. 772) [mailto:Niall.Hannon@f...]
Sent: Thursday, July 11, 2002 12:28 PM
To: sql language
Subject: [sql_language] This is IMPOSSIBLE!


Hi,

Heres a sql problem that I dont think is possible but I am open to 
being
corrected.

I have 2 tables, tableA and tableB. Pretty simple so far!

TableA:
ID
Project
Role
Days

TableB:
ID
Project
Role
Days

So both tables have same design but different data.

I need to return, using SQL, all the records in TableA plus all the
records in TableB that do not appear in TableA. Here is the tricky part
- I need to look at 2 fields when checking if the records in TableB
exist in TableA. i.e Project and Role fields.

Check the record and look at the Project and Role field values. If they
exist in TableA for the record then ignore it, otherwise I need it
returned in the SQL set. This is easy when looking at just 1 field -

	"Select DAYS from TableA union select DAYS from TableB where
project not in(select project from TableA)"

But how do you do this when I want to say something like.....where
project and Role not in(select project from TableA)? Its not
possible!!!!!

Thanks
Niall


************************************************************************

**
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the recipient
named above. If you are not the intended recipient or a representative
of the intended recipient, you have received this e-mail in error and
must not copy, use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please notify the
sender immediately by return e-mail and permanently delete the copy you
received. This email has been swept for computer viruses. However, you
should carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
************************************************************************

**