how's this:
<!--- first query --->
<cfquery name="q1">
select User, Job
from sometable
where somecriteria
</cfquery>
<cfif q1.recordcount>
<!--- 2nd --->
<cfquery>
select ID, User, Job
from table1
where
<cfloop query="q1">
(User <> '#q1.User#'
AND
Job <> '#q1.Job#')
OR
</cfloop>
1 = 0
</cfquery>
</cfif>
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"Justin"
<JustinMacCarthy@ To: "Cfuk" <[EMAIL PROTECTED]>
online.ie> cc:
Subject: [ cf-dev ] SQL question
05/12/2003 14:26
Please respond to
dev
If I have
table 1
--------------------
user job
--------------------
joe manager
sam Staff
harry manager
and a query that returns
--------------------
user job
--------------------
joe manager
harry manager
dick staff
is there a way to get this (i.e. anyone in table1 that don't have matching
rows in the query) in SQL
----------------
User job
----------------
Sam staff
Thanks Justin
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
