I have two tables : tblagrcrop
========================================
ID int(11) No 0
ProvID int(11) Yes 0
Year char(50) utf8_general_ci Yes NULL
Data int(11) Yes 0
and tblprov
ProvID int(11) No 0
ProvName char(50) utf8_general_ci Yes NULL
and I want to display as proid 1999 2000 2001
1 201 506 210
2 178 563 152