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