Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT(
- if(movimentacaograde.gr01<>0, CONCAT(ROUND(movimentacaograde.gr01,0),'-',grade.DescGr01, ', '), ''),
- if(movimentacaograde.gr02<>0, CONCAT(ROUND(movimentacaograde.gr02,0),'-',grade.DescGr02, ', '), ''),
- if(movimentacaograde.gr03<>0, CONCAT(ROUND(movimentacaograde.gr03,0),'-',grade.DescGr03, ', '), ''),
- if(movimentacaograde.gr04<>0, CONCAT(ROUND(movimentacaograde.gr04,0),'-',grade.DescGr04, ', '), ''),
- if(movimentacaograde.gr05<>0, CONCAT(ROUND(movimentacaograde.gr05,0),'-',grade.DescGr05, ', '), ''),
- if(movimentacaograde.gr06<>0, CONCAT(ROUND(movimentacaograde.gr06,0),'-',grade.DescGr06, ', '), ''),
- if(movimentacaograde.gr07<>0, CONCAT(ROUND(movimentacaograde.gr07,0),'-',grade.DescGr07, ', '), ''),
- if(movimentacaograde.gr08<>0, CONCAT(ROUND(movimentacaograde.gr08,0),'-',grade.DescGr08, ', '), ''),
- if(movimentacaograde.gr09<>0, CONCAT(ROUND(movimentacaograde.gr09,0),'-',grade.DescGr09, ', '), ''),
- if(movimentacaograde.gr10<>0, CONCAT(ROUND(movimentacaograde.gr10,0),'-',grade.DescGr10, ', '), ''),
- if(movimentacaograde.gr11<>0, CONCAT(ROUND(movimentacaograde.gr11,0),'-',grade.DescGr11, ', '), ''),
- if(movimentacaograde.gr12<>0, CONCAT(ROUND(movimentacaograde.gr12,0),'-',grade.DescGr12, ', '), ''),
- if(movimentacaograde.gr13<>0, CONCAT(ROUND(movimentacaograde.gr13,0),'-',grade.DescGr13, ', '), ''),
- if(movimentacaograde.gr14<>0, CONCAT(ROUND(movimentacaograde.gr14,0),'-',grade.DescGr14, ', '), ''),
- if(movimentacaograde.gr15<>0, CONCAT(ROUND(movimentacaograde.gr15,0),'-',grade.DescGr15, ', '), ''),
- if(movimentacaograde.gr16<>0, CONCAT(ROUND(movimentacaograde.gr16,0),'-',grade.DescGr16, ', '), ''),
- if(movimentacaograde.gr17<>0, CONCAT(ROUND(movimentacaograde.gr17,0),'-',grade.DescGr17, ', '), ''),
- if(movimentacaograde.gr18<>0, CONCAT(ROUND(movimentacaograde.gr18,0),'-',grade.DescGr18, ', '), ''),
- if(movimentacaograde.gr19<>0, CONCAT(ROUND(movimentacaograde.gr19,0),'-',grade.DescGr19, ', '), ''),
- if(movimentacaograde.gr20<>0, CONCAT(ROUND(movimentacaograde.gr20,0),'-',grade.DescGr20, ', '), ''),
- if(movimentacaograde.gr21<>0, CONCAT(ROUND(movimentacaograde.gr21,0),'-',grade.DescGr21, ', '), ''),
- if(movimentacaograde.gr22<>0, CONCAT(ROUND(movimentacaograde.gr22,0),'-',grade.DescGr22, ', '), ''),
- if(movimentacaograde.gr23<>0, CONCAT(ROUND(movimentacaograde.gr23,0),'-',grade.DescGr23, ', '), ''),
- if(movimentacaograde.gr24<>0, CONCAT(ROUND(movimentacaograde.gr24,0),'-',grade.DescGr24, ', '), ''),
- if(movimentacaograde.gr25<>0, CONCAT(ROUND(movimentacaograde.gr25,0),'-',grade.DescGr25, ', '), ''),
- if(movimentacaograde.gr26<>0, CONCAT(ROUND(movimentacaograde.gr26,0),'-',grade.DescGr26, ', '), ''),
- if(movimentacaograde.gr27<>0, CONCAT(ROUND(movimentacaograde.gr27,0),'-',grade.DescGr27, ', '), ''),
- if(movimentacaograde.gr28<>0, CONCAT(ROUND(movimentacaograde.gr28,0),'-',grade.DescGr28, ', '), ''),
- if(movimentacaograde.gr29<>0, CONCAT(ROUND(movimentacaograde.gr29,0),'-',grade.DescGr29, ', '), ''),
- if(movimentacaograde.gr30<>0, CONCAT(ROUND(movimentacaograde.gr30,0),'-',grade.DescGr30, ', '), '')
- ) AS DESCRICAO
- from movimentacaograde inner join subnf on subnf.codigo = movimentacaograde.CodigoOrigem left join grade on grade.codigo = subnf.CodigoGrade where (movimentacaograde.CodigoOrigem = 280 AND movimentacaograde.TipoOrigem = 2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement