Hi,

I have been trying to retrieve data from 2 different(Products,Registration) lists using Joins.
Below is the query which is used

SELECT
ProductName,
a,
b,
c,
d,
e,
f,
g,
h,
j,
i
from Products, Registration where Products.ProductName = Registration.ProductName

This throws up an error which says ambiguos column ProductName

Please help me with the correct join statement.

Thanks in Advance.