SELECT distinct nf.documentno, TO_CHAR(nf.dateissued, 'DDMM') AS data FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id GROUP BY nf.documentno, nf.dateissued;
SELECT nf.documentno, SUM(nfl.price * nfl.qty) FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id GROUP BY nf.documentno;
SELECT nf.documentno, SUM(nfl.price * nfl.qty + (nfl.price * nfl.qty * nfl.rateipi/100)) total FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id GROUP BY nf.documentno;
SELECT nf.documentno nf, cfop.name cfop FROM compiere.c_notafiscal nf, compiere.c_cfop cfop WHERE nf.documentno > 289 AND nf.documentno < 348 AND cfop.c_cfop_id = nf.c_cfop_id GROUP BY documentno, cfop.name;
SELECT nf.documentno nf, bp.taxidbr1 cnpj FROM compiere.c_notafiscal nf, compiere.c_bpartner bp WHERE nf.documentno > 289 AND nf.documentno < 348 AND bp.c_bpartner_id = nf.c_bpartner_id GROUP BY documentno, taxidbr1;
SELECT nf.documentno nf, bp.taxidbr2 ie FROM compiere.c_notafiscal nf, compiere.c_bpartner bp WHERE nf.documentno > 289 AND nf.documentno < 348 AND bp.c_bpartner_id = nf.c_bpartner_id GROUP BY documentno, taxidbr2;
SELECT nf.documentno nf, bp.name ie FROM compiere.c_notafiscal nf, compiere.c_bpartner bp WHERE nf.documentno > 289 AND nf.documentno < 348 AND bp.c_bpartner_id = nf.c_bpartner_id GROUP BY documentno, bp.name;
SELECT nf.documentno, SUM(nfl.price * nfl.qty * (1+nfl.rateipi/100)) FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id AND nfl.rateipi >= 1 GROUP BY nf.documentno;
SELECT nf.documentno, nfl.rateicms FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id GROUP BY nf.documentno, nfl.rateicms;
SELECT nf.documentno, SUM(nfl.rateicms * nfl.price * nfl.qty * (1+nfl.rateipi/100)) FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id AND nfl.rateipi > 0 AND nfl.rateicms > 0 GROUP BY nf.documentno;
SELECT nf.documentno, SUM(nfl.price * nfl.qty) valor FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id AND nfl.rateicms = 0 GROUP BY nf.documentno;
SELECT nf.documentno, SUM(nfl.price * nfl.qty * (nfl.rateipi/100)) FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id GROUP BY nf.documentno;
SELECT nf.documentno, SUM(nfl.price * nfl.qty) icms FROM compiere.c_notafiscal nf, compiere.c_notafiscalline nfl WHERE nf.documentno > 289 AND nf.documentno < 348 AND nf.c_notafiscal_id = nfl.c_notafiscal_id AND nfl.rateipi = 0 GROUP BY nf.documentno;
o que eu quero agora é ajuntar todas as colunas em uma só query, pois cada select tem 2 colunas e uma é em comum pra todos (documentno)... tem como fazer isso???
Obrigado a todos