Menu
Community /Pin to ProfileBookmark
@NogDogDec 22.2020 — #Might be able to do it with a case statement
(Typed that off the top of my head, so you may need to check the manual if there are any syntax errors. ;) )
Get one of two column values
I’ve got a MySQL query. I have a column in table A which has either 1 or 2 as it’s value (always).
My query JOINS a second table. I need to get the value from column X or Z from this table.
This is decided on my 1 or 2 from table A. If it’s 1, then get the value from column X if 2 then Z.
Can this be done?
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogDec 22.2020 — #Might be able to do it with a case statement<i>
</i>select
a.col_1,
case
when a.col_1 = 1 then b.col_x
else b.col_z
end as meaningful_name
from table_a as a
inner join table_b as b on a.something = b.something_else
(Typed that off the top of my head, so you may need to check the manual if there are any syntax errors. ;) )