Hi
How do I get the subquery T1.CODE value to be displayed as part of the main query?
Thanks heaps
SELECT CopyTIMEENTRY.TCT, tblPayrollOfficers.TCTNAME, CopyTIMEENTRY.EMP_ID, CopyTIMEENTRY.NAME, CopyTIMEENTRY.TRANSDATE, CopyTIMEENTRY.CODE
FROM tblPayrollOfficers INNER JOIN CopyTIMEENTRY ON tblPayrollOfficers.PO = CopyTIMEENTRY.TCT
WHERE (((CopyTIMEENTRY.CODE)="a654" or CopyTIMEENTRY.CODE ="a655") AND ((Exists (SELECT T1.CODE AS CODE1 FROM CopyTIMEENTRY as T1 WHERE CopyTIMEENTRY.EMP_ID = T1.EMP_ID AND CopyTIMEENTRY.TRANSDATE = T1.TRANSDATE AND (T1.CODE = "A630" or T1.CODE = "A636" )))=True))
ORDER BY CopyTIMEENTRY.TCT, CopyTIMEENTRY.NAME, CopyTIMEENTRY.TRANSDATE;
How do I get the subquery T1.CODE value to be displayed as part of the main query?
Thanks heaps
SELECT CopyTIMEENTRY.TCT, tblPayrollOfficers.TCTNAME, CopyTIMEENTRY.EMP_ID, CopyTIMEENTRY.NAME, CopyTIMEENTRY.TRANSDATE, CopyTIMEENTRY.CODE
FROM tblPayrollOfficers INNER JOIN CopyTIMEENTRY ON tblPayrollOfficers.PO = CopyTIMEENTRY.TCT
WHERE (((CopyTIMEENTRY.CODE)="a654" or CopyTIMEENTRY.CODE ="a655") AND ((Exists (SELECT T1.CODE AS CODE1 FROM CopyTIMEENTRY as T1 WHERE CopyTIMEENTRY.EMP_ID = T1.EMP_ID AND CopyTIMEENTRY.TRANSDATE = T1.TRANSDATE AND (T1.CODE = "A630" or T1.CODE = "A636" )))=True))
ORDER BY CopyTIMEENTRY.TCT, CopyTIMEENTRY.NAME, CopyTIMEENTRY.TRANSDATE;