Hi
I've the following tables
(holds a list of companies)
TableName:Company
CompanyID (int)
CompanyName (varchar)
(holds a list of areas)
TableName:Area
AreaID (int)
AreaName (varchar)
(holds a list of what areas are near to what companies),
TableName:AreaCompanys
CompanyID (int)
AreaID (int)
Nearby (y/n)
For example company1 is listed under area 1 but is nearby to area 2, company2
is listed under area 2 and is nearby to area 3.
Based on this could I obtain a list of areas if I passed area 2 to the query.
From the above example I would expect to get back the following :
Area1 Name
Area2 Name
Thanks for any help
Neil
_________________________________________________________________
Be one of the first to try Windows Live Mail.
http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
