Can someone please explain what "v.*" means in the 1st line? Also what does the "v" mean in the FROM line?Code:SELECT distinct v.*, [cUser].cEmail, [oHRCurrent].ojSuperSSN as cSuperSSN, [oHRCurrent].ojDivision as cDivision, [oHRCurrent].ojDepartment as cDepartment FROM [v_employee_list_names] v JOIN [iMaster] ON v.[iKey]=[iMaster].[iKey] JOIN [oHRBase] ON [iMaster].[iKey]=[oHRBase].[oKeyMaster] JOIN [oHRCurrent] ON [oHRBase].[oKey]=[oHRCurrent].[oKeyBase] JOIN [cUser] ON [iMaster].[iSSN]=[cUser].[cSSN] AND [cUser].[cKeyCompany]=v.[iKeyCompany] WHERE v.[iKeyCompany]=1442 AND oHRCurrent.oPSID = 'FLX2' AND v.[iKey] <> 0 ORDER BY v.[iName]
[v_employee_list_names] is a view
this is for SQL Sever 2000
thanks
Dimava




Reply With Quote