Hi Matt,
I think that you have ID missmatch between those two tables. The following select will return all ID's from OGC table not found in OutbackLogin table.
SELECT OGC.OGCID
from OGC LEFT OUTER join OutbackLogin ON OGC.OGCID = OutbackLogin.OLUserID
WHERE OutbackLogin.OLUserID IS NULL
GROUP BY 1
>The results for that query are:
>
>ADMIN 6
>CSR 21
>OGC 276
>TM 48
>
>>Can you run one more query and post result?
>>
SELECT OutbackLogin.OLUserType, COUNT(*)
>>FROM OutbackLogin
>>GROUP BY 1
>>
>>>When I run the query below it just returns this:
>>>
>>>OGC 10072 10590
>>>
>>>>Can you just cut and paste those two lines?
>>>>
>>>>>I would, but there is a total of 278 records that it returns from the table whenever I run the query.
>>>>>
>>>>>>Can you post results for CSR and ADMIN usertypes? Just copy it from QA result window.
>>>>>>
>>>>>>>I ran your code in a query and the results return where that the minimum number was 10072 and the maximum number was 10590
>>>>>>>
>>>>>>>>In this case something wrong in your logic. Run following select to see Id ranges for each usertype.
SELECT OutbackLogin.OLUserType, MIN(OGC.OGCID), MAX(OGC.OGCID)
>>>>>>>>from OGC inner join OutbackLogin ON OGC.OGCID = OutbackLogin.OLUserID
>>>>>>>>GROUP BY 1
>>>>>>>>
>>>>>>< snip >
--sb--