There is no unique table in this query.

The query needs to unambiguously identify which table to return values from.

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance