SQL Error

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Does anyone know why I get the following error? The
specified field () could refer to more than one table
listed in the FROM clause of your SQL statement?
 
You have a field called, say, "Field1" and that field name exists in 2 or
more of the tables in the SQL statement. The statement only includes the
name of the field, not the name of the table and field

You'll have to refer to the table and field name, ie.
[table1].[field1] instead of just [field1]

hth,
-M
 
Back
Top