D
DS
I have two queries that I want to join. I want to use SQL so that I can
eliminate the queries how would I do this?
Query 6
SELECT tblChecks.ChkTabID, tblChecks.ChkAlias, tblChecks.CheckID,
tblChecks.ChkTaxCodeID, tblChecks.ChkGuests, tblChecks.ChkPaid,
tblChecks.ChkServer, tblChecks.ChkPrinted, tblChecks.ChkDividedCheck,
tblChecks.ChkTypeID, tblChecks.ChkCancelled, tblChecks.ChkFXSep
FROM tblChecks
GROUP BY tblChecks.ChkTabID, tblChecks.ChkAlias, tblChecks.CheckID,
tblChecks.ChkTaxCodeID, tblChecks.ChkGuests, tblChecks.ChkPaid,
tblChecks.ChkServer, tblChecks.ChkPrinted, tblChecks.ChkDividedCheck,
tblChecks.ChkTypeID, tblChecks.ChkCancelled, tblChecks.ChkFXSep
HAVING (((tblChecks.ChkPaid)=0) AND ((tblChecks.ChkPrinted)=0) AND
((tblChecks.ChkDividedCheck)=0) AND ((tblChecks.ChkTypeID) Not Like 5) AND
((tblChecks.ChkCancelled)=0) AND ((tblChecks.ChkFXSep)=0));
Query 7
SELECT Query6.ChkServer, [EmpFirstName] & " " & [EmpLastName] AS EMP
FROM Query6 INNER JOIN tblEmployees ON Query6.ChkServer =
tblEmployees.EmployeeID
GROUP BY Query6.ChkServer, [EmpFirstName] & " " & [EmpLastName]
ORDER BY [EmpFirstName] & " " & [EmpLastName];
Thanks
DS
eliminate the queries how would I do this?
Query 6
SELECT tblChecks.ChkTabID, tblChecks.ChkAlias, tblChecks.CheckID,
tblChecks.ChkTaxCodeID, tblChecks.ChkGuests, tblChecks.ChkPaid,
tblChecks.ChkServer, tblChecks.ChkPrinted, tblChecks.ChkDividedCheck,
tblChecks.ChkTypeID, tblChecks.ChkCancelled, tblChecks.ChkFXSep
FROM tblChecks
GROUP BY tblChecks.ChkTabID, tblChecks.ChkAlias, tblChecks.CheckID,
tblChecks.ChkTaxCodeID, tblChecks.ChkGuests, tblChecks.ChkPaid,
tblChecks.ChkServer, tblChecks.ChkPrinted, tblChecks.ChkDividedCheck,
tblChecks.ChkTypeID, tblChecks.ChkCancelled, tblChecks.ChkFXSep
HAVING (((tblChecks.ChkPaid)=0) AND ((tblChecks.ChkPrinted)=0) AND
((tblChecks.ChkDividedCheck)=0) AND ((tblChecks.ChkTypeID) Not Like 5) AND
((tblChecks.ChkCancelled)=0) AND ((tblChecks.ChkFXSep)=0));
Query 7
SELECT Query6.ChkServer, [EmpFirstName] & " " & [EmpLastName] AS EMP
FROM Query6 INNER JOIN tblEmployees ON Query6.ChkServer =
tblEmployees.EmployeeID
GROUP BY Query6.ChkServer, [EmpFirstName] & " " & [EmpLastName]
ORDER BY [EmpFirstName] & " " & [EmpLastName];
Thanks
DS