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? Link to comment https://forums.phpfreaks.com/topic/81767-purpose-of-join/ 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. Link to comment https://forums.phpfreaks.com/topic/81767-purpose-of-join/#findComment-415420 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? Link to comment https://forums.phpfreaks.com/topic/81767-purpose-of-join/#findComment-415446 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 Link to comment https://forums.phpfreaks.com/topic/81767-purpose-of-join/#findComment-415450 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. Link to comment https://forums.phpfreaks.com/topic/81767-purpose-of-join/#findComment-415506 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.