Create view in mysql
Budget: ₹600 – ₹1,500 INR
I need to create view in mysql database taking sum from multiple tables
1. By 9 tables to single create view tbl
2 . 3 tables to single create view tbl
"SELECT sum(amount) as total FROM `tbl1` WHERE user_id='$user_id' and type='2' and blocked!='1'");
"SELECT sum(amount) as total FROM `tbl2` WHERE user_id='$user_id'
"SELECT sum(amount) as total FROM tbl3 WHERE user_id='$user_id'
"SELECT sum(amount) as total FROM tbl4 WHERE user_id='$user_id' "
"SELECT sum(amount) as total FROM tbl5 WHERE user_id='$user_id' and blocked!='1'"
"SELECT sum(amount) as total FROM tbl6 WHERE user_id='$user_id'
"select sum(amount) as crypto_amt from tbl7 where user_id='$user_id' and credit_status='1'
"SELECT sum(amount) as total FROM tbl9 WHERE user_id='$user_id' "
"select sum(amount) as usedtotal from tbl10 where user_id='$user_id'"
1. By 9 tables to single create view tbl
2 . 3 tables to single create view tbl
"SELECT sum(amount) as total FROM `tbl1` WHERE user_id='$user_id' and type='2' and blocked!='1'");
"SELECT sum(amount) as total FROM `tbl2` WHERE user_id='$user_id'
"SELECT sum(amount) as total FROM tbl3 WHERE user_id='$user_id'
"SELECT sum(amount) as total FROM tbl4 WHERE user_id='$user_id' "
"SELECT sum(amount) as total FROM tbl5 WHERE user_id='$user_id' and blocked!='1'"
"SELECT sum(amount) as total FROM tbl6 WHERE user_id='$user_id'
"select sum(amount) as crypto_amt from tbl7 where user_id='$user_id' and credit_status='1'
"SELECT sum(amount) as total FROM tbl9 WHERE user_id='$user_id' "
"select sum(amount) as usedtotal from tbl10 where user_id='$user_id'"