Hi,
i have sql like here:
where can i use aliases for tables?
please help,
Jacek
i have sql like here:
Code:
SELECT qryIm_Temp_SystemVersionsNMtblSystemVersions3.*, tblSystemVersions.SystemVersionID
FROM qryIm_Temp_SystemVersionsNMtblSystemVersions3 INNER JOIN tblSystemVersions ON (qryIm_Temp_SystemVersionsNMtblSystemVersions3.VersionName = tblSystemVersions.VersionName)
AND (qryIm_Temp_SystemVersionsNMtblSystemVersions3.BundleID = tblSystemVersions.BundleID) AND (qryIm_Temp_SystemVersionsNMtblSystemVersions3.Function = tblSystemVersions.Function) AND (qryIm_Temp_SystemVersionsNMtblSystemVersions3.VersionID = tblSystemVersions.VersionID);
where can i use aliases for tables?
please help,
Jacek