Another stupid question (relational select)
Posted: Thu Jul 27, 2006 5:14 pm
OK, I just bought an O'Reilly book on mysql and it's on it's way, so soon I will stop asking these stupid questions (hopefully) but for now...
I have table one with business info, table two with points info, and table three (that relates them) with business_id & points_id. How do i select all the business information, but with the lat and lon values from points...
my tables:
businesses:
id
name
owner
address
phone
points:
id
lat
lon
businesses_points:
business_id
point_id
I have table one with business info, table two with points info, and table three (that relates them) with business_id & points_id. How do i select all the business information, but with the lat and lon values from points...
my tables:
businesses:
id
name
owner
address
phone
points:
id
lat
lon
businesses_points:
business_id
point_id