I have database with following level of data.....
field1(id) field2 field3 field4 field5
123 1 Prod1 132 3477573
123 2 prod2 345 7657984
123 3 prod3 405 5947575
123 4 prod4 234 8749579
the user want to look data as
field1 (prod1's field2) (prod2's field2) (prod4's field2) (prod2'sfield5) (prod4'sfield5)
123 1 2 4 7657984 8749579
I have each Prod in different tables......field4 and field 5 are in one table.......here field1,field2 and field3 are in ID level and field4,field5 are in field2 level.......
so I am unable to represent data as user wish to see........