MYSQL/PHP Get values from JOIN of same column name

Question

SELECT admin.User, a.time

FROM admin 

LEFT JOIN a ON admin.User=a.User

LEFT JOIN b ON admin.User=a.User

So I have three tables, admin then a & b. At the moment I get tables a & b by joining via a shared field called User. However tables a & b have a field called 'types' which is not in the admin table.

What I want to do is instead of select 'types' twice - once for table a and once for table b, is have the 'types' field combined so there is only one results set for that field.

Alfred Huang · Accepted Answer · 2014-06-04 14:39:34Z

1

try to use ifnull(a.types, b.types) as types to export the field. (MySQL)

so that it try to get a.types first, if that yields null, then yields b.types instead.

answered Jun 4, 2014 at 14:39

Alfred Huang

18.4k33 gold badges128 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL/PHP Get values from JOIN of same column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related