I have a table of tenants with data as follows:
Suite............Ten1Last .............Ten1First
101..............Smith...................Joe
101..............Smith...................Mary
I want to do this to the data with a query:
Suite.......Ten1Last..........Ten1First.......Ten2Last......Ten2 First
101.........Smith...............Joe.............. Smith...........Mary
You might say I want to un-normalize the data. Any help is appreciated.
Suite............Ten1Last .............Ten1First
101..............Smith...................Joe
101..............Smith...................Mary
I want to do this to the data with a query:
Suite.......Ten1Last..........Ten1First.......Ten2Last......Ten2 First
101.........Smith...............Joe.............. Smith...........Mary
You might say I want to un-normalize the data. Any help is appreciated.