VB.net SQL The objects in the FROM Clause have the same exposed names
Posted on 2014-07-24
Hi. I get the following error in the SQL Statement built below. How do I rectify this
The objects Polycom_Products and Polycom_Products in the FROM Clause have the same exposed names. Use correlation names to distinguish them
Dim sSQL As String
sSQL = "Select Polycom_Products.*, Photos.* "
sSQL = sSQL & " From Polycom_Products Left Join Photos On Polycom_Products.Category2 = Photos.Category2 And Polycom_Products.Category3 = Photos.Category3"
sSQL = sSQL & ",Polycom_Products Left Join Costs On Polycom_Products.[Product ID] = Costs.[ProdID]"