conditional join in mysql

by

You can’t do it directly like that… you can do something like this though (not very pretty…):

SELECT
t.id,
t.type,
t2.id AS id2,
t3.id AS id3

FROM t
LEFT JOIN t2 ON t2.id = t.id AND t.type="t2"
LEFT JOIN t3 ON t3.id = t.id AND t.type="t3"

More Related Contents:

  1. left join query keep a column empty
  2. How can I select data from different tables?
  3. MySQL Conditional Insert
  4. MySQL: Quick breakdown of the types of joins [duplicate]
  5. Join between tables in two different databases?
  6. MySQL JOIN ON vs USING?
  7. Required to join 2 tables with their FKs in a 3rd table
  8. CROSS/OUTER APPLY in MySQL
  9. Mixing ANSI 1992 JOINs and COMMAs in a query
  10. Cumulative sum over a set of rows in mysql
  11. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  12. MySql Count cannot show 0 values
  13. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  14. How do I use properly CASE..WHEN in MySQL
  15. MySQL JOIN the most recent row only?
  16. mysql query show multiple tables from one ID column
  17. LEFT JOIN only first row
  18. MySQL JOIN with LIMIT 1 on joined table
  19. MySQL Inner Join Query Multiple Tables
  20. Difference between these two joining table approaches?
  21. Laravel join with 3 Tables
  22. MySQL Insert & Joins
  23. How to join two tables using a comma-separated-list in the join field
  24. MySQL LEFT JOIN 3 tables
  25. What is the default MySQL JOIN behaviour, INNER or OUTER?
  26. MySQL Join Where Not Exists
  27. how to use a like with a join in sql?
  28. When to use a left outer join?
  29. MySQL cartesian product between two SELECT statements
  30. MySQL Multiple Joins in one query?

Leave a Comment