Superb Logic Using Union
1. MYSQL\n\nselect product_id,\'store1\' as store,store1 as price from products where store1 is not null\nunion \nselect product_id,\'store2\' as store,store2 a
# 1. MYSQL\n```\nselect product_id,\'store1\' as store,store1 as price from products where store1 is not null\nunion \nselect product_id,\'store2\' as store,store2 as price from products where store2 is not null\nunion\nselect product_id,\'store3\' as store,store3 as price from products where store3 is not null\n```\n# please upvote me it would encourage me alot\n
['MySQL']