This sounds like a basic SQL question - if so,
maybe this is what you want:
"select EmpNo, Name, Status, Date from MyRecords
where EmpNo = 1000", or,
"select EmpNo, Name, Status, Date from MyRecords
where Status = 'Sick Leave'", or,
"select EmpNo, Name, Status, Date from MyRecords
where Date = '01-Jan-03'", or.....
----- Original Message -----
Sent: Sunday, February 02, 2003 1:43
AM
Subject: Enhydra: Supporting help
....
I am facing some problem. Please help me ! I have
a attendance table, Every day i entry employee present and absent time and one
status column to maintain employee's present or absent status.
I entry one month data at that table and I wish
to write a query , that can show individual employee record with in one
row..as like this example table ....
My Actual Table
EmpNo
Name
Status Date
----------- --------- ---------- ---------
1000 Mr.
Joy Sick
Leave 01-Jan-03
1000 Mr.
Joy Present
02-Jan-03
1000 Mr.
Joy Absent
03-Jan-03
1000 Mr.
Joy Present
04-Jan-03
My SQL query should be display ....
EmpNo
Name
Present Absent
Sick
Leave
----------- --------- ---------- ----------- --------------
1000 Mr.
Joy
2 1 1
Please, Help me " How can i write this type of
SQL Query "
Thanks and Beast Regards ...
G.K.M. Shafiul Alam Bhuiyan
(Computer
Programmer)
_______________________________________________
Enhydra mailing list Enhydra@xxxxxxxxxxx
http://www.enhydra.org/mailman/listinfo.cgi/enhydra
