| :: Joining tables :: (2) | Post a New Message | Post a Reply |
 Joining tables | Post a Reply |
since: Oct 9, 2003
from: somewhere
I have been trying out the free version using the MS Northwind database.
I've been trying to Join two tables (Employees and EmployeeTerritories). Both tables have an EmployeeID column.
When I build the report and include one or both of the EmployeeID fields I get the following error
-2147217900
[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'EmployeeID'
Is there any way to prevent this?
In SQL Profiler the sql being executed is
select * from SELECT EmployeeID,Title,HireDate,Address,City,ReportsTo,EmployeeID,TerritoryID FROM Employees,EmployeeTerritories
(There is 2 'select' keywords in the statement which is strange.)
Thanks.
| Re: Joining tables | Post a Reply |
from: Washington, DC
-------------------------
Ghost