Hello!
I need a SQL Expert who can assist me in writing a SQL Query.
I have 5 Tables. Every table has a field with a Code.
Now i want a new table with every entry from the other tables with the same code in one row.
Example:
Table one fields: "building","more fields", "Code",
Table two fields: "room","more fields", "Code",
Table three fields: "plant","more fields", "Code"
Final Table: "building1", "more fields", "Room1 of buidling1","more fields", "room2 of buiding1","more fields","plant1 of building1","more fields"....etc
one building. many rooms, plants are possible
Hi Buyer
Hope doing well,
we are interested to do job and have the ability to win this project and your trust with yours maximum satisfaction.
Kindly Check PM