Please Help Urgent

[dheeraja]

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...

[jdavidbakr]

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