jeudi 9 avril 2020

select query in IF ststement MYSQL

In MY select query I want an output look like this:

in my select query i want a column output as 1, if the column value present in a list returned by a select query else 0 .

Select col1,col2, ,IF col3 IN ((select col from tabl2 ),1,0)AS col5 from tbl1.

Thanks in Advance

Aucun commentaire:

Enregistrer un commentaire