I have two tables:
1. town [fields: townid, town, areaid]
2. lga (local government area) [fields: id, townid, lganame]
Town tbl gives a full list of towns, LGA tbl gives a breakdown of suburbs within the towns.
I need to write an SQL SELECT statement (Server 2008) that will bring back one column of information with a full list of towns and lgas for that area. The two tbl's are related on the townid field.
Previously I was only looking up town names with this statment:
SELECT town FROM town WHERE areaid = 8 ORDER BY town
How do I do this?