Hi,
I want to joint 2 tables with different date types :
Table 1:
Employee Month workHour
AAB 201112 90
BBS 201112 110
Table2:
Employee dateDebut dateFin activités
AAB 12/01/2011 08:00 12/08/2011 08:00 sick leave
AAB 12/10/2011 08:00 12/12/2011 08:00 Training
BBS 12/02/2011 08:00 12/23/2011 08:00 sick leave
purpose is jointing 2 tables in order to make wage slip like that:
Employee Month workHour sick leave Training
AAB Dec 2011 90 8j*24h 2j*24h
BBS Dec 2011 110 19j*24h 0
Can I realise this joint by making a view with SQL? or other solution?
Who can help me,thanks!!!!
Edited by sophieTaureau - 07 Mar 2012 at 8:39am
IP Logged