Mysql expert
Budget: $2 – $8 USD
Hello Dear all,
I want simple mysql query where if else condition in join
so if column value = A then join on another column if column value is B then join on another column.
So
SELECT * FROM table A LEFT JOIN table B
if A.name = 'ABC' then ON a.email=b.email
if A.name = 'DEF' then ON A.email=B.email_long
I want simple mysql query where if else condition in join
so if column value = A then join on another column if column value is B then join on another column.
So
SELECT * FROM table A LEFT JOIN table B
if A.name = 'ABC' then ON a.email=b.email
if A.name = 'DEF' then ON A.email=B.email_long