rashmi_k28 Posted November 14, 2008 Share Posted November 14, 2008 How to select count(field) from table1; select count(field) from table2; How to get count(*) from table1 and also from table2 from a single query Link to comment https://forums.phpfreaks.com/topic/132677-count/ Share on other sites More sharing options...
zenag Posted November 14, 2008 Share Posted November 14, 2008 SELECT count( field )as count1 , ( SELECT count( field ) FROM table2 ) AS count2 FROM table1 Link to comment https://forums.phpfreaks.com/topic/132677-count/#findComment-690023 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.