Simple But It's Late 1

[JurkMonkey]

I have a table which simply contains UserID and BuildingID.

I need to pull the data from the Building table using the results of a specific userid in the first table.


Users
ID Name
1 Timmy
2 Billy
3 Joe

Building
ID Address
1 123 Main St
2 456 Water Rd

MyTable
ID UserID BuildingID
1 2 2

I would expect to return Billy 456 Water Rd.

Someone got some SQL for me?

Thanks

 

[r937]

select Users.Name
     , Building.Address
  from MyTable
inner
  join Users
    on Users.ID = MyTable.UserID
inner
  join Building
    on Building.ID = MyTable.BuildingID

r937.com | rudy.ca

 

[JurkMonkey]

Thanks!

P.S. Your business is located about 10 minutes from where I live.

 

[r937]

my business is located about 10 centimetres from where i live

;-)

r937.com | rudy.ca