ORA-00918: column ambiguously defined in SELECT *

A query’s projection can only have one instance of a given name. As your WHERE clause shows, you have several tables with a column called ID. Because you are selecting * your projection will have several columns called ID. Or it would have were it not for the compiler hurling ORA-00918.

The solution is quite simple: you will have to expand the projection to explicitly select named columns. Then you can either leave out the duplicate columns, retaining just (say) COACHES.ID or use column aliases: coaches.id as COACHES_ID.

Perhaps that strikes you as a lot of typing, but it is the only way. If it is any comfort, SELECT * is regarded as bad practice in production code: explicitly named columns are much safer.

Related Posts:

  1. ORA-00918: column ambiguously defined in SELECT *
  2. ORA-00918: column ambiguously defined in SELECT *
  3. ORA-00904: invalid identifier
  4. how to fix oracle ORA-01722 invalid number error
  5. ORA-00979 not a group by expression
  6. ORA-00907: missing right parenthesis
  7. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  8. ORA-01843 not a valid month- Comparing Dates
  9. Oracle error : ORA-00905: Missing keyword
  10. How do I limit the number of rows returned by an Oracle query after ordering?
  11. Oracle SELECT TOP 10 records
  12. Can a foreign key be NULL and/or duplicate?
  13. How to Select Top 100 rows in Oracle?
  14. ORA-12560: TNS:protocol adaptor error
  15. ORA-00972 identifier is too long alias column name
  16. Oracle Apex column link from LOV values
  17. PLS-00103: Encountered the symbol when expecting one of the following:
  18. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  19. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  20. ORA-01861: literal does not match format string
  21. What is it exactly a BLOB in a DBMS context
  22. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  23. How do you create a temporary table in an Oracle database?
  24. Oracle “Partition By” Keyword
  25. How to insert date values into table
  26. Oracle SQL: Update a table with data from another table
  27. SQL selecting rows by most recent date with two unique columns
  28. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  29. Comparing Dates in Oracle SQL
  30. Convert timestamp to date in Oracle SQL
  31. How do I reset a sequence in Oracle?
  32. Update statement with inner join on Oracle
  33. MySQL equivalent of DECODE function in Oracle
  34. Oracle: If Table Exists
  35. DATEDIFF function in Oracle
  36. How to create id with AUTO_INCREMENT on Oracle?
  37. LEFT function in Oracle
  38. What is the difference between Views and Materialized Views in Oracle?
  39. How do I view the Explain Plan in Oracle Sql developer?
  40. ORA-01779: cannot modify a column which maps to a non key-preserved table
  41. ORA-01735: invalid ALTER TABLE option – Toad
  42. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  43. What is a stored procedure?
  44. Conversion failed when converting date and/or time from character string while inserting datetime
  45. QL Error: ORA-00933: SQL command not properly ended
  46. MySQL create table if not exists and insert record only if table was created
  47. error, string or binary data would be truncated when trying to insert
  48. Why do we need “Relationships” between tables at all?
  49. Using group by on multiple columns
  50. How to declare a variable in MySQL?
  51. How do I escape a single quote in SQL Server?
  52. SQL Error: ORA-00942 table or view does not exist
  53. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  54. How Stuff and ‘For Xml Path’ work in SQL Server?
  55. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  56. must appear in the GROUP BY clause or be used in an aggregate function
  57. How can I return pivot table output in MySQL?
  58. Compare dates in MySQL
  59. Best way to do nested case statement logic in SQL Server
  60. The multi-part identifier could not be bound
  61. What does the following Oracle error mean: invalid column index
  62. MySQL syntax for Join Update
  63. SQLite – UPSERT *not* INSERT or REPLACE
  64. how to drop partition without dropping data in MySQL?
  65. Simple way to calculate median with MySQL
  66. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  67. Error 1046 No database Selected, how to resolve?
  68. Is there a combination of “LIKE” and “IN” in SQL?
  69. How to SUM and SUBTRACT using SQL?
  70. SELECT DISTINCT on one column
  71. TSQL PIVOT MULTIPLE COLUMNS
  72. MySQL – UPDATE multiple rows with different values in one query
  73. How to create a MySQL hierarchical recursive query?
  74. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  75. Equivalent of Oracle’s RowID in SQL Server
  76. Subtract one day from datetime
  77. SQL Server: Make all UPPER case to Proper Case/Title Case
  78. How do I query for all dates greater than a certain date in SQL Server?
  79. Backup a single table with its data from a database in sql server 2008
  80. updating table rows in postgres using subquery
  81. Is there a coalesce-like function in Excel?
  82. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  83. MySQL LIKE IN()?
  84. Filter data based on date in sql
  85. SQL query to extract only the “current” wp_posts?
  86. How to retrieve sticky post in raw sql?
  87. How to remove in the wordpress database all posts revisions except the last three?
  88. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  89. $wpdb get_var issue
  90. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  91. Inserting rows into a custom table, when plugin is activated
  92. dbDelta not creating table (yes, once more)
  93. Posts modified in the last 48 hours
  94. post id not displaying
  95. How to export 2 week’s worth of posts
  96. Insert multiple checkbox values
  97. How to get EVENT based on startday, using BETWEEN
  98. wpdb prepare without placeholder
  99. How to get the sum of each post with the same date
  100. How to dump a Microsoft SQL Server database to a SQL script?

Leave a Comment