Show the specific field on mysql table based on active date
- by mrjimoy_05
Suppose that I have 3 tables:
A) Table UsrHeader
-----------------
UsrID | UsrName
-----------------
1 | Abc
2 | Bcd
B) Table UsrDetail
-------------------------------
UsrID | UsrLoc | Date
-------------------------------
1 | LocA | 10 Aug 2012
1 | LocB | 15 Aug 2012
2 | …