Ambiguous column name error

by

Because ARTIFACTTYPE can refer to either A.ARTIFACTTYPE or B.ARTIFACTTYPE and the server needs to know which one you want, just change it to A.ARTIFACTTYPE and you should be okay in this case.

To clarify, you need to specify the alias prefix any time the column name is ambiguous. It isn’t bad practice to always use alias prefixes as it makes it clear which columns are coming from which tables when you read the query, and eliminates issues like this one.

One might wonder why you need to distinguish between which of two columns you want when they both refer to the same column in the same table. The answer is that when you join a table to itself, the values from A.column and B.column may be different depending on the join criteria (such as may be the case with an outer join where values in one of the columns may be null).

More Related Contents:

  1. conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  2. I dont know sql syntax for my table [closed]
  3. Making a dynamic pivot table but without using the fiddle
  4. Get top 1 row of each group
  5. How to cast the DateTime to Time
  6. Convert Datetime column from UTC to local time in select statement
  7. Why is SQL Server losing a millisecond?
  8. Generate a resultset of incrementing dates in TSQL
  9. Find a string by searching all tables in SQL Server
  10. How do I split a delimited string so I can access individual items?
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  14. Why use Select Top 100 Percent?
  15. How do I find duplicates across multiple columns?
  16. SQL Server UNION – What is the default ORDER BY Behaviour
  17. How to get last 7 days data from current datetime to last 7 days in sql server
  18. sql varchar(max) vs varchar(fix)
  19. How to check which locks are held on a table
  20. store arabic in SQL database
  21. What is the Null Character literal in TSQL?
  22. Convert Date format into DD/MMM/YYYY format in SQL Server
  23. SQL Server : SUM() of multiple rows including where clauses
  24. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  25. How to combine results of two queries into a single dataset
  26. SQL Server 2005 and temporary table scope
  27. Cumulative Total in MS Sql server [duplicate]
  28. Export table data from one SQL Server to another
  29. Count consecutive duplicate values in SQL
  30. How to improve performance for datetime filtering in SQL Server?

Leave a Comment