Fix my SQL please :)

[Saint Nick]

SELECT b.Empl_Nbr, b.Qlfn_Code as MainQlfn_Code, a.Qlfn_Code as LicHistQlfnCode
FROM DVMS_Main as b
(
SELECT DVMS_LicHist.Empl_Nbr, DVMS_LicHist.Qlfn_Code, max(DVMS_LicHist.EntryDate) as Qlfn_CodeDate
FROM DVMS_LicHist
GROUP BY DVMS_LicHist.Empl_Nbr, DVMS_LicHist.Qlfn_Code
ORDER BY DVMS_LicHist.Empl_Nbr
) as a
WHERE b.Qlfn_Code <> a.Qlfn_Code

Just giving me a syntax error. Does it have to do with my aliases?

 

[Snapster]

You cannot have the order by in your subquery, and you forgot a comma after b to differentiate the sources.

SELECT b.Empl_Nbr, b.Qlfn_Code as MainQlfn_Code, a.Qlfn_Code as LicHistQlfnCode
FROM DVMS_Main as b,
(
SELECT DVMS_LicHist.Empl_Nbr, DVMS_LicHist.Qlfn_Code, max(DVMS_LicHist.EntryDate) as Qlfn_CodeDate
FROM DVMS_LicHist
GROUP BY DVMS_LicHist.Empl_Nbr, DVMS_LicHist.Qlfn_Code
) as a
WHERE b.Qlfn_Code <> a.Qlfn_Code