Down here
tHE First query result is 267
tHE Second query result is 211
The Thirth and four query result is empty.
My question is whyyyyyyyyyyyyyyyyyyyyyy???
Thanks friends in advance and forgive my desperate state.
regards Mario
////////////////////////////////////////
// First Query
SELECT COUNT(DISTINCT EbethCustRpt3.UserName) AS Expr1
FROM EbethCustRpt3 EbethCustRpt3 LEFT OUTER JOIN
tblUsers tblUsers ON EbethCustRpt3.nameFirst =
tblUsers.nameFirst AND EbethCustRpt3.nameLast = tblUsers.nameLast
WHERE (EbethCustRpt3.Completed = 'Yes')
////////////////////////////////////////
// Second Query
SELECT COUNT(DISTINCT EbethCustRpt3.UserName) AS Expr1
FROM EbethCustRpt3 EbethCustRpt3 INNER JOIN
tblUsers tblUsers ON EbethCustRpt3.nameFirst =
tblUsers.nameFirst AND EbethCustRpt3.nameLast = tblUsers.nameLast
WHERE (EbethCustRpt3.Completed = 'Yes')
///////////////
// Thirth Query
SELECT nameFirst, nameLast
FROM EbethCustRpt3
WHERE (NOT EXISTS
(SELECT tblUsers.nameFirst,
EbethCustRpt3.nameLast
FROM tblUsers))
////////////////////////////
// Four Query
SELECT nameFirst, nameLast
FROM tblUsers
WHERE (NOT EXISTS
(SELECT EbethCustRpt3.nameFirst,
EbethCustRpt3.nameLast
FROM EbethCustRpt3))
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
