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