con questa recupero l'orario di lavoro e in alternativa la causale (uno esclude l'altro) corrispondente alla posizione della turnazioneOriginariamente inviata da IncorrectSintax
codice:SELECT AZIENDA,TURNAZIONE,POSIZIONE,CAUSALE,OR_FISSO FROM TURNAZIONI_CICLI
azienda turn pos causale or_fisso
000000A153 A5 1 NULL X5AN
000000A153 A5 2 NULL X5AN
000000A153 A5 3 NULL X5AN
000000A153 A5 4 NULL X5AN
000000A153 A5 5 NULL X5AN
000000A153 A5 6 RPT NULL
000000A153 A5 7 RPT NULL
000000A153 GG3 1 RPT NULL
000000A153 GG3 2 NULL X5AN
000000A153 GG3 3 NULL X5AN
000000A153 GG3 4 NULL X5AN
000000A153 GG3 5 NULL X5AN
000000A153 GG3 6 NULL X5AN
000000A153 GG3 7 RPT NULL
000000A153 GG3 8 NULL X5AN
000000A153 GG3 9 RPT NULL
000000A153 GG3 10 NULL X5AN
000000A153 GG3 11 NULL X5AN
000000A153 GG3 12 NULL X5AN
000000A153 GG3 13 NULL X5AN
000000A153 GG3 14 RPT NULL
000000A153 GG3 15 NULL X5AN
000000A153 GG3 16 NULL X5AN
000000A153 GG3 17 RPT NULL
000000A153 GG3 18 NULL X5AN
000000A153 GG3 19 NULL X5AN
000000A153 GG3 20 NULL X5AN
000000A153 GG3 21 RPT NULL
000000A153 GG3 22 NULL X5AN
000000A153 GG3 23 NULL X5AN
000000A153 GG3 24 NULL X5AN
000000A153 GG3 25 RPT NULL
000000A153 GG3 26 NULL X5AN
000000A153 GG3 27 NULL X5AN
000000A153 GG3 28 RPT NULL
000000A153 GG3 29 NULL X5AN
000000A153 GG3 30 NULL X5AN
000000A153 GG3 31 NULL X5AN
000000A153 GG3 32 NULL X5AN
000000A153 GG3 33 RPT NULL
000000A153 GG3 34 RPT NULL
000000A153 GG3 35 NULL X5AN
000000A153 S004 1 NULL X6AN
000000A153 S004 2 NULL X6AN
000000A153 S004 3 NULL X6AN
000000A153 S004 4 RPT NULL
000000A153 S004 5 RPT NULL
000000A153 S004 6 NULL X6AN
000000A153 S004 7 NULL X6AN
000000A153 S004 8 NULL X6AN
000000A153 S004 9 RPT NULL
000000A153 S004 10 RPT NULL
000000A153 S004 11 NULL X6AN
000000A153 S004 12 NULL X6AN
000000A153 S004 13 NULL X6AN
000000A153 S004 14 RPT NULL
000000A153 S004 15 RPT NULL
000000A153 S004 16 NULL X6AN
000000A153 S004 17 NULL X6AN
000000A153 S004 18 NULL X6AN
000000A153 S004 19 RPT NULL
000000A153 S004 20 RPT NULL
000000A153 S004 21 NULL X6AN
000000A153 S004 22 NULL X6AN
000000A153 S004 23 NULL X6AN
000000A153 S004 24 RPT NULL
000000A153 S004 25 RPT NULL
000000A153 S004 26 NULL X5AN
000000A153 S004 27 NULL X6AN
000000A153 S004 28 NULL X6AN
000000A153 S004 29 RPT NULL
000000A153 S004 30 RPT NULL
000000A153 S004 31 NULL X6AN
000000A153 S004 32 NULL X6AN
000000A153 S004 33 NULL X6AN
000000A153 S004 34 RPT NULL
000000A153 S004 35 RPT NULL
000000A153 S005 1 NULL X5AN
000000A153 S005 2 NULL X5AN
000000A153 S005 3 NULL X4AN
000000A153 S005 4 RPT X5AN
000000A153 S005 5 NULL X5AN
000000A153 S005 6 NULL X5AN
000000A153 S005 7 NULL X4AN
000000A153 S005 8 RPT X5AN
000000A153 S005 9 NULL X5AN
000000A153 S005 10 NULL X5AN
000000A153 S005 11 NULL X4AN
000000A153 S005 12 RPT X5AN
000000A153 S005 13 NULL X5AN
000000A153 S005 14 NULL X5AN
000000A153 S005 15 NULL X4AN
000000A153 S005 16 RPT X5AN
000000A153 S005 17 NULL X5AN
000000A153 S005 18 NULL X5AN
000000A153 S005 19 NULL X5AN
000000A153 S005 20 RPT X5AN
000000A153 S005 21 NULL X5AN
000000A153 S005 22 NULL X5AN
000000A153 S005 23 NULL X4AN
000000A153 S005 24 RPT X5AN
000000A153 S005 25 NULL X5AN
000000A153 S005 26 NULL X5AN
000000A153 S005 27 NULL X5AN
000000A153 S005 28 RPT X5AN
000000A153 S006 1 NULL X6AN
000000A153 S006 2 NULL X6AN
000000A153 S006 3 NULL X6AN
000000A153 S006 4 RPT X6AN
000000A153 S006 5 NULL X6AN
000000A153 S006 6 NULL X5AN
000000A153 S006 7 NULL X5AN
000000A153 S006 8 RPT X6AN
000000A153 S006 9 NULL X6AN
000000A153 S006 10 NULL X6AN
000000A153 S006 11 NULL X6AN
000000A153 S006 12 RPT X6AN
000000A153 S006 13 NULL X5AN
000000A153 S006 14 NULL X5AN
000000A153 S006 15 NULL X6AN
000000A153 S006 16 RPT X6AN
000000A153 S006 17 NULL X6AN
000000A153 S006 18 NULL X6AN
000000A153 S006 19 NULL X6AN
000000A153 S006 20 RPT X6AN
000000A153 S006 21 NULL X5AN
000000A153 S006 22 NULL X6AN
000000A153 S006 23 NULL X6AN
000000A153 S006 24 RPT X6AN
000000A153 S006 25 NULL X6AN
000000A153 S006 26 NULL X6AN
000000A153 S006 27 NULL X5AN
000000A153 S006 28 RPT X6AN
000000A153 S007 1 NULL X5GN
000000A153 S007 2 NULL X5GN
000000A153 S007 3 RPT NULL
000000A153 S007 4 NULL X5GN
000000A153 S007 5 NULL X5GN
000000A153 S007 6 RPT NULL
000000A153 S007 7 RPT NULL
000000A153 S007 8 NULL X5GN
000000A153 S007 9 RPT NULL
000000A153 S007 10 NULL X5GN
000000A153 S007 11 NULL X5GN
000000A153 S007 12 RPT NULL
000000A153 S007 13 NULL X5GN
000000A153 S007 14 NULL X5GN
000000A153 S007 15 RPT NULL
000000A153 S007 16 NULL X5GN
000000A153 S007 17 NULL X5GN
000000A153 S007 18 RPT NULL
000000A153 S007 19 NULL X5GN
000000A153 S007 20 NULL X5GN
000000A153 S007 21 RPT NULL
000000A153 S008 1 NULL X6AN
000000A153 S008 2 NULL X6AN
000000A153 S008 3 NULL X6AN
000000A153 S008 4 NULL X6AN
000000A153 S008 5 NULL X6AN
000000A153 S008 6 RPT X6AN
000000A153 S008 7 RPT X6AN
000000A153 S008 8 NULL X6AN
000000A153 S008 9 NULL X6AN
000000A153 S008 10 NULL X6AN
000000A153 S008 11 RPT X6AN
000000A153 S008 12 RPT X6AN
000000A153 S008 13 NULL X6AN
000000A153 S008 14 NULL X6AN
000000A153 S008 15 NULL X6AN
000000A153 S008 16 NULL X6AN
000000A153 S008 17 RPT X6AN
000000A153 S008 18 NULL X6AN
000000A153 S008 19 NULL X6AN
000000A153 S008 20 NULL X6AN
000000A153 S008 21 RPT X6AN
000000A153 S008 22 NULL X6AN
000000A153 S008 23 RPT X6AN
000000A153 S008 24 NULL X6AN
000000A153 S008 25 NULL X6AN
000000A153 S008 26 NULL X6AN
000000A153 S008 27 NULL X6AN
000000A153 S008 28 RPT X6AN
000000A153 S008 29 RPT X6AN
000000A153 S008 30 NULL X6AN
000000A153 S008 31 NULL X6AN
000000A153 S008 32 NULL X6AN
000000A153 S008 33 NULL X6AN
000000A153 S008 34 NULL X6AN
000000A153 S008 35 RPT X6AN
000000A153 S010 1 NULL X6AN
000000A153 S010 2 NULL X6AN
000000A153 S010 3 NULL X6AN
000000A153 S010 4 RPT NULL
000000A153 S010 5 RPT NULL
000000A153 S010 6 NULL X6AN
000000A153 S010 7 NULL X6AN
000000A153 S010 8 NULL X6AN
000000A153 S010 9 RPT NULL
000000A153 S010 10 RPT NULL
000000A153 S010 11 NULL X6AN
000000A153 S010 12 NULL X6AN
000000A153 S010 13 NULL X6AN
000000A153 S010 14 RPT NULL
000000A153 S010 15 RPT NULL
000000A153 S010 16 NULL X6AN
000000A153 S010 17 NULL X6AN
000000A153 S010 18 NULL X5AN
000000A153 S010 19 RPT NULL
000000A153 S010 20 RPT NULL
000000A153 S010 21 NULL X6AN
000000A153 S010 22 NULL X6AN
000000A153 S010 23 NULL X6AN
000000A153 S010 24 RPT NULL
000000A153 S010 25 RPT NULL
000000A153 S010 26 NULL X6AN
000000A153 S010 27 NULL X6AN
000000A153 S010 28 NULL X6AN
000000A153 S010 29 RPT NULL
000000A153 S010 30 RPT NULL
000000A153 S010 31 NULL X6AN
000000A153 S010 32 NULL X6AN
000000A153 S010 33 NULL X6AN
000000A153 S010 34 RPT NULL
000000A153 S010 35 RPT NULL
000000A153 S011 1 NULL X5AN
000000A153 S011 2 NULL X5AN
000000A153 S011 3 NULL X5AN
000000A153 S011 4 NULL X5AN
000000A153 S011 5 NULL X5AN
000000A153 S011 6 RPT NULL
000000A153 S011 7 RPT NULL
000000A153 S011 8 NULL X5AN
000000A153 S011 9 NULL X5AN
000000A153 S011 10 NULL X5AN
000000A153 S011 11 RPT NULL
000000A153 S011 12 RPT NULL
000000A153 S011 13 NULL X5AN
000000A153 S011 14 NULL X5AN
000000A153 S011 15 NULL X5AN
000000A153 S011 16 NULL X5AN
000000A153 S011 17 RPT NULL
000000A153 S011 18 NULL X5AN
000000A153 S011 19 NULL X5AN
000000A153 S011 20 NULL X5AN
000000A153 S011 21 RPT NULL
000000A153 S011 22 NULL X5AN
000000A153 S011 23 RPT NULL
000000A153 S011 24 NULL X5AN
000000A153 S011 25 NULL X5AN
000000A153 S011 26 NULL X5AN
000000A153 S011 27 NULL X5AN
000000A153 S011 28 RPT NULL
000000A153 S011 29 RPT NULL
000000A153 S011 30 NULL X5AN
000000A153 S011 31 NULL X5AN
000000A153 S011 32 NULL X5AN
000000A153 S011 33 NULL X5AN
000000A153 S011 34 NULL X5AN
000000A153 S011 35 RPT NULL
Rispondi quotando