1.

Correlated Sub Query?

Answer»

SELECT A.DRIVER_REFERENCE
FROM CGDEV4.TU4ML A
WHERE A.LICENSE_NUMBER = 'POTAPA*355B2' AND
A.DRIVER_REFERENCE =
(SELECT C.CLIENT_REFERENCE
FROM CGDEV4.TZ1SR C
WHERE A.DRIVER_REFERENCE = C.CLIENT_REFERENCE AND
SUBSTR(C.Z_UPPER_FIRST_NAME,1,1) = 'A' AND
SUBSTR(C.Z_UPPER_LAST_NAME,1,3) = 'JZB')

SELECT A.DRIVER_REFERENCE
FROM CGDEV4.TU4ML A
WHERE A.LICENSE_NUMBER = 'POTAPA*355B2' AND
A.DRIVER_REFERENCE =
(SELECT C.CLIENT_REFERENCE
FROM CGDEV4.TZ1SR C
WHERE A.DRIVER_REFERENCE = C.CLIENT_REFERENCE AND
SUBSTR(C.Z_UPPER_FIRST_NAME,1,1) = 'A' AND
SUBSTR(C.Z_UPPER_LAST_NAME,1,3) = 'JZB')


Discussion

No Comment Found

Related InterviewSolutions