Please Help Urgent

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dheeraja
Forum Commoner
Posts: 36
Joined: Tue Nov 09, 2010 11:03 pm

Please Help Urgent

Post by 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...
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: Please Help Urgent

Post by Darhazer »

You need something like:

Code: Select all

select table1.*, count(report_table).id as reports_count FROM
table1 inner join report_table using(supervisor)
where  startdate = "2010-11-20" and enddate  = "2010-11-27"
GROUP BY supervisor ORDER BY reports_count ASC
Post Reply