LanceT Posted December 15, 2007 Share Posted December 15, 2007 Can anyone explain to me why some programmers use the join? Is this just to keep the database organized? Quote Link to comment Share on other sites More sharing options...
tippy_102 Posted December 15, 2007 Share Posted December 15, 2007 A JOIN combines data from 2 (or more) tables and allows you to keep related information in seperate tables. When you're first stating out, they seem like an extra, unnecessary step, but as your projects become more complex, you will be greatful someone thought of it. Quote Link to comment Share on other sites More sharing options...
LanceT Posted December 15, 2007 Author Share Posted December 15, 2007 Thanks, but can anyone point me to a site where I can best learn how to use join and some scenarios I would want to use it in? Quote Link to comment Share on other sites More sharing options...
tippy_102 Posted December 15, 2007 Share Posted December 15, 2007 http://www.tizag.com/sqlTutorial/sqljoin.php http://php.about.com/od/learnmysql/ss/mysql_joins.htm Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted December 15, 2007 Share Posted December 15, 2007 JOINs make it easier to normalize your database as tippy hinted at. Without JOINs, some operations would take several database queries to perform; with proper use of JOINs, you can perform most tasks in a single query and avoid placing unnecessary burden on the MySQL server. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.