Mar 25, 20080
Mysql and Inner joins - Simple Guide
Categories: Code Monkey
When writing code in MySQL, you don't need to write inner joins. Well you do, but you don't need to say "INNER JOIN" MySQL uses a dot syntax which makes our code so much easier. Our example uses 3 tables with several columns each. A table of users, a table of DVD's and a table showing who has borrowed what and when. Users: id,Name DVD: id, Title, genre loans: id,owner,Title,Date So we have entries in all of these tables. And we want to retrieve a list of all ... Read More
