Venituri cheltuieli alegeri (view)

Data source: Expert Forum · About: Metodologie

1 row where Alegeri = "2012P" and Partid = "PAS"

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE VIEW "Venituri cheltuieli alegeri" AS SELECT Alegeri, "Tip alegeri", Partid, Venituri, Cheltuieli FROM 'Cheltuieli campanie' WHERE "Tip competitor" = 'p' UNION SELECT Alegeri, 'Tip alegeri', Partid, Venituri, Cheltuieli FROM 'Venituri și cheltuieli campanie' WHERE "Tip competitor" = 'p';