Pull record from multiple rows 4

[dk2006]

Hi all,
I feel stupid for not knowing how to do this though it might be very simple to do.

table I have

ID Name AddressType Address
1 John Business 123 Test Dr
1 John Home 345 Jackson St
2 Bart Business PO Box 123
2 Bart Home 1234 Low Dr

I want a query to return

ID Name BusinessAddress HomeAddress
1 John 123 Test Dr 345 Jackson St
2 Bart PO Box 123 1234 Low Dr

Please help

Thank you,

Sam

 

[dk2006]

Barislav,
You found the answer for me. Million thanks. I would give you another star but it only accept one from me.

thanks again,

sam

 

[sunila7]

The queries suggested above should have worked. It looks like there is some thing more with the data. if you could provide data for the tables in question specifically for the rows that are being duplicated we could probably be able to help you better.


Sunil

 

[gmmastros]

Sam, Boris is good like that. I'll give him a star for you.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom