查詢mysql其中數(shù)據(jù),mysql查詢多個表的數(shù)據(jù)組合成列表?
select s.num1,t.num2 from (select count(*) num1 from student) s, (select count(*) num2 from teacher) t;分別用兩個子查詢查出兩個標的記錄,即臨時表,然后列出來就可以。有問題再留言
select s.num1,t.num2 from (select count(*) num1 from student) s, (select count(*) num2 from teacher) t;分別用兩個子查詢查出兩個標的記錄,即臨時表,然后列出來就可以。有問題再留言