Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
GIS
Starting Member
9 Posts |
Posted - 2014-07-16 : 02:33:18
|
Hi, in my code below I'd like to present 3 columns but getting error, how to change it? Thanksselect banks.Municipality,banks.Num_Branches,cities.Population from banks b inner join cities c on(b.Municipality= c.Municipality) |
|
mhorseman
Starting Member
44 Posts |
Posted - 2014-07-16 : 03:26:06
|
You've aliased the tables, so your select should be something like:select b.Municipality,b.Num_Branches,c.PopulationMark |
|
|
GIS
Starting Member
9 Posts |
Posted - 2014-07-16 : 11:17:25
|
Thanks Mark |
|
|
|
|
|