1 2 3 4 5 6 7 8
|
insert into table1(pointageid,annee,enfantaccueilid,enfantid,accueilid,datedebut,arrivee,depart,duree,prevision)
select-7408,enfantaccueil.annee,enfantaccueil.enfantaccueilid, enfantaccueil.accueilid, enfantaccueil.enfantid, anneedate.jour,
'16:30:00','18:00','01:30' ,1 as prevision from table2 inner join table3 on enfantaccueil.annee = anneedate.annee
where table3.joursemaine = 1 and table2.enfantaccueilid = -135 and table3.jour >= '2012-10-01'
and table3.jour <= '2013-09-10'
and table3.semaine in ( 2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46,48,50,52) |
Partager