Introduction
In part one of this article we looked at the basics of SQL including SELECT, INSERT, UPDATE and DELETE queries. In this, the final part of the article, we're going to learn about joins and sub queries. After reading both part 1 and 2 of this article, you should be able to construct intermediate SQL queries to extract and manipulate data from both single and multiple tables.
Read More...
Speaking SQL part 2 Categories : General SQL , Databases , MySQL Speaking SQL part 1 Categories : Databases , General SQL Saving Images in MySQL Categories : MySQL , PHP , Graphics , Databases PHP 101 Part 8 of 15 : Databases and Other Animals Categories : PHP , Beginner Guides , Databases How To add paging (Pagination) with PHP and MySQL Categories : PHP , Beginner Guides , Databases , MySQL , HTML and PHP Simple Connection to Oracle with PHP Categories : PHP , Oracle , Databases Introduction to using PHP 5.0 and SQLite Categories : PHP , SQLite , Databases Watching The Web Categories : PHP , Databases , MySQL , HTTP , MD5 Referer Statistics Categories : PHP , MySQL , HTTP , Databases PHP 101 Part 9 of 15 : SQLite My Fire! Categories : PHP , Beginner Guides , Databases , SQLite Simple Connection to PostgreSQL with PHP Categories : PHP , PostgreSQL , Databases Access vs. MySQL Categories : Databases , MySQL , MS Access Beginners guide to PHP and MySQL Categories : PHP , Beginner Guides , Databases , MySQL , Installation Descriptions of Common Data Types Categories : MySQL , Databases , PHP , PHP options/info , General Apache, PHP, and PostgreSQL on RedHat Linux Categories : Apache , PHP , Databases , PostgreSQL , Linux