Re: SQL Problem

[Benjamin Pflugmann <benjamin-mysql@xxxxxxxxxxxx>]

Hi.

This is dicussed here:

http://www.mysql.com/doc/G/r/Group_by_functions.html
(after the function list)

http://www.mysql.com/doc/E/x/Examples.html (see the subsections)

Bye,

	Benjamin.


On Sat, Nov 24, 2001 at 11:01:26PM +0530, mmehta@xxxxxxxxxxxxxxxx wrote:
> Hello Everyone,
> 
> I wants to find the max. date and Login status of employee for Attendance
> table.
> The qurey runs fine but it shows me the wrong status.
> 
> select max(a.dAtt_Date),a.nLog_Status from tbl_attendance a,tbl_attendance b
> where a.nEmp_id = 1 and a.nLog_Status = b.nLog_Status
> group by b.nEmp_id
[...]

-- 
benjamin-mysql@xxxxxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92428@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php