dheeraja Posted November 24, 2010 Share Posted November 24, 2010 Hi Guys, I am scratching my head to fetch the data from two tables having some conditions. Suppose I am having a table called "table1" having the field Table 1 [id(int) auto_inc, owner (int), supervisor (int), startdate (date), enddate(date), status (tinyint)] report_table [id(int) auto_inc, owner (int), supervisor(int), prdate(date), status(tinyint), project(int), component(int), workdone(text)] Now I want to know that the supervisor from table1 with startdate say "2010-11-20" and enddate "2010-11-27" submitted how many reports in report_table. that means I want to count the number of reports from 2nd table and arrange it in ascending order on the basis of count. So please anyone help me... Quote Link to comment Share on other sites More sharing options...
jdavidbakr Posted November 24, 2010 Share Posted November 24, 2010 Have you looked at the MySQL manual for the count() syntax? http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_count Quote Link to comment 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.