SQL select join: is it possible to prefix all columns as ‘prefix.*’?

by

It seems the answer to your question is no, however one hack you can use is to assign a dummy column to separate each new table. This works especially well if you’re looping through a result set for a list of columns in a scripting language such as Python or PHP.

SELECT '' as table1_dummy, table1.*, '' as table2_dummy, table2.*, '' as table3_dummy, table3.* FROM table1
JOIN table2 ON table2.table1id = table1.id
JOIN table3 ON table3.table1id = table1.id

I realize this doesn’t answer your question exactly, but if you’re a coder this is a great way to separate tables with duplicate column names.

More Related Contents:

  1. What is the result of following SQL Query?
  2. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  3. Join vs. sub-query
  4. Can I use CASE statement in a JOIN condition?
  5. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  6. SQL join: selecting the last records in a one-to-many relationship
  7. Subqueries vs joins
  8. Does the join order matter in SQL?
  9. Difference between left join and right join in SQL Server [duplicate]
  10. What is the difference between JOIN and UNION?
  11. Filter Table Before Applying Left Join
  12. SQL Join Differences
  13. Difference between natural join and inner join
  14. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  15. Natural join in SQL Server
  16. Including null values in an Apache Spark Join
  17. Is a JOIN faster than a WHERE?
  18. Select only rows by join tables max value
  19. Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?
  20. What is semi-join in database?
  21. Merge two rows in SQL
  22. Joining multiple tables in SQL
  23. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  24. sql sum data from multiple tables
  25. SQL server join tables and pivot
  26. SQL Inner Join On Null Values
  27. INNER JOIN vs multiple table names in “FROM” [duplicate]
  28. Join a count query on generate_series() and retrieve Null values as ‘0’
  29. Re-Writing “Fuzzy Join” Functions from R to SQL
  30. Procedurally transform subquery into join

Leave a Comment