i have a table in that table 4 column Id , FirmId, OfficeId, PlanID
Data Like Below
Id FirmId OfficeId PlanID
------------------------------
1 54 0 4
2 54 3 9
3 54 5 8
4 54 6 4
5 54 7 9
6 54 8 8
FirmID 54 has 10 Office
if office does not conains plan then it will refer a firmid and officeid Null planid
like Office 1,2,9,10 does not contains plan so it will refer a FirmId = 54 And Office id = 0 Plan
Now i want result Like Below
Id FirmId OfficeId PlanID
-----------------------------------------
1 54 1 4
1 54 2 4
2 54 3 9
3 54 5 8
4 54 6 4
5 54 7 9
6 54 8 8
1 54 9 4
1 54 10 4