Alegeri extra (view)

Data source: Expert Forum · About: Metodologie

1 row where Competitori = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Alegeri Tip Descriptiv Data desfășurării Data Candidați Competitori Independenți Venituri Cheltuieli
2014EUR EUR Parlamentul European 25 mai 2014 25.05.2014 579 23   12222397 21159896

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW "Alegeri extra" AS SELECT a.*, b.Venituri, b.Cheltuieli FROM (SELECT Cod AS Alegeri, Tip, Descriptiv, "Data desfășurării", Data, Candidați, Competitori, Independenți FROM 'Legenda alegeri') a JOIN (SELECT alegeri, Venituri, Cheltuieli FROM "Venituri cheltuieli alegeri - total" ) b on a.Alegeri = b.Alegeri;