All,

To me these two statements appear the same:

SELECT authorization_tracking.PATID, ;
authorization_tracking.units_remaining, ;
authorization_tracking.authorization_effective_date, ;
authorization_tracking.authorization_expiration_date, ;
authorization_tracking.payer_code, authorization_tracking.facility, ;
services_for_authorization.service_code ;
FROM authorization_tracking ;
JOIN services_for_authorization ON ;
STR (authorization_tracking.facility) + ;
authorization_tracking.patid + authorization_tracking.aut_link== ;
STR(services_for_authorization.facility) + ;
services_for_authorization.patid + ;
services_for_authorization.aut_link ;
where authorization_expiration_date >={^1999-09-01} AND ;
authorization_status_value <> PADR('Denied',30) AND ;
authorization_tracking.facility=GCOUNTY AND ISNULL(void_code) ;
ORDER BY authorization_tracking.PATID ;
INTO CURSOR authtemp

-- Lists 5525 records

SELECT authorization_tracking.PATID, ;
authorization_tracking.units_remaining, ;
authorization_tracking.authorization_effective_date, ;
authorization_tracking.authorization_expiration_date, ;
authorization_tracking.payer_code, authorization_tracking.facility, ;
services_for_authorization.service_code ;
FROM authorization_tracking ;
JOIN services_for_authorization ON ;
authorization_tracking.facility=services_for_authorization.facility ;
and authorization_tracking.patid=services_for_authorization.patid ;
and ;
authorization_tracking.aut_link=services_for_authorization.aut_link ;
WHERE authorization_expiration_date >={^1999-09-01} AND ;
authorization_status_value <> PADR('Denied',30) AND ;
authorization_tracking.facility=GCOUNTY AND ISNULL(void_code) ;
ORDER BY authorization_tracking.PATID ;
INTO CURSOR authtemp

-- List 28333 Records

What am I missing.

TIA,
Doug