Sunday, 8 September 2013

getting data from two tables which have the same 'where' clause

getting data from two tables which have the same 'where' clause

My first SQL
"SELECT `PM_Amount_Total_Paid` FROM `payments_master` WHERE RG_Reg_N0=?"
My second SQL
"SELECT * FROM `registrations` WHERE RG_Reg_NO=?"
How can I join these two SQL clauses into one?

No comments:

Post a Comment