Jon Klubnik
asked on
correlation names in a sql query
error when trying to make sql query. Error says. "The objects "TBL_CONTACT" and "TBL_CONTACT" in the FROM clause have the same exposed names. Use correlation names to distinguish them.The objects "TBL_CONTACT" and "TBL_CONTACT" in the FROM clause have the same exposed names. Use correlation names to distinguish them."
SELECT [TBL_CONTACT].[LASTNAME], [tbl_Contact].[CONTACTID], TBL_PHONE.NUMBERVALUE
from TBL_CONTACT join TBL_CONTACT on TBL_CONTACT.CONTACTID=TBL_ PHONE.CONT ACTID
SELECT [TBL_CONTACT].[LASTNAME], [tbl_Contact].[CONTACTID],
from TBL_CONTACT join TBL_CONTACT on TBL_CONTACT.CONTACTID=TBL_
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER