reset password
Author Message
jpascua
Posts: 197
Posted 14:52 Jun 11, 2015 |

Can someone hint on how are we to join the tables? They don't share a common attribute.

Are joins even necessary for this assignment?

Thanks in advance.

Last edited by jpascua at 14:54 Jun 11, 2015.
ytsai8
Posts: 47
Posted 15:02 Jun 11, 2015 |

You don't need to join the tables for this assignment, you are to find all the stores within the specific radius. 

But if you really want to join tables, you can check http://www.w3schools.com/sql/sql_join_left.asp

else check http://stackoverflow.com/questions/574691/mysql-great-circle-distance-haversine-formula