mardi 19 mars 2019

how do I update SQL columns with true or false based data in another column on the same table?

Snap

PLease see attached image

I would like to update 'Supplier' & 'Agent' Columns with either true or false, based on the info in the "Supplier_Agent" column. How would i do this? Also, some records do not have any info in the "Supplier_Agent" column so for them, both 'Supplier' & 'Agent' Columns would be FALSE.

Aucun commentaire:

Enregistrer un commentaire