Hi all, I'm writting a query with CASE, CAST, COALESCE... Is there any possibility to express this using table object or class mapped? ------------------
SELECT bolletta.numero as nr_doc, bolletta.data_emissione as data_doc, anagrafica.nome as rag_sociale, comune.nome as comune, anagrafica.dato_fiscale as p_iva, CASE WHEN tariffa.aliquota_iva = 0 THEN importo ELSE 0.00 END as fuori_campo, CASE WHEN tariffa.aliquota_iva > 0 THEN importo ELSE 0.00 END as imponibile, cast(importo*tariffa.aliquota_iva/100 as decimal(10,2)) as iva, cast(importo+coalesce(bolletta.imposta_bollo,0)+(importo*tariffa.aliquota_iva/100) as decimal(10,2)) as totale, aa_bolletta_na||'/'||nr_bolletta_na as rif_na, imposta_bollo,bolletta.sezionale FROM bolletta, comune, anagrafica, figura_aziendale, bolletta_dettaglio, tariffa WHERE figura_aziendale.id_anagrafica = anagrafica.id AND anagrafica.id_comune = comune.id AND bolletta.cliente = figura_aziendale.id AND bolletta_dettaglio.cod_tariffa = tariffa.codice AND bolletta_dettaglio.aa_bolletta = bolletta.anno AND bolletta_dettaglio.nr_bolletta = bolletta.numero ----------- jo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---