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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/132677-count/#findComment-690023 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.