Visual Representation of SQL Joins Introduction This is just a simple article visually explaining SQL JOINs. Background I'm a pretty visual person. Things seem to make more sense as a picture. Using the code I am going to discuss seven different ways you can return data from two relational tables. For the sake of this article, I'll refer to 5, 6, and 7 as LEFT EXCLUDING JOIN, RIGHT EXCLUDING JOIN, and OUTER EXCLUDING JOIN, respectively. Inner JOIN This is the simplest, most understood Join and is the most common. Hide Copy Code SELECT <select_list> FROM Table_A A INNER JOIN Table_B B ON A.Key = B.Key Left JOIN This query will return all of the records in the left table (table A) regardless if any of those records have a match in the right table (table B). SELECT <select_list>FROM Table_A A LEFT JOIN Table_B B ON A.Key = B.Key Right JOIN This query will return all of the records in the right table (table B) regardless if any of those records have a match in the left table (table A). Outer JOIN Left Excluding JOIN Examples History
phpMyFAQ homepage - open source FAQ system for PHP and MySQL, PostgreSQL and other databases | welcome RadRails Free, open source IDE for Ruby and Rails applications RadRails is now included as part of Aptana Studio 3. No extra download required--now integrated into a single editor. Core Capabilities Code Assist Quick access to Ruby, HTML, CSS and JavaScript structures, methods, elements, properties, tags & attributes. Code Assist Integrated Debugger Set breakpoints, inspect variables, control execution. Integrated Debugger Outlining View and navigate the structures in your file using this hierarchical outline of your Ruby or HTML page. Outlining
e-Bills web enabled billing and customer care: user and developer community web-based XHTML editor - Home PHP Dox: Ajax Powered PHP Documentation Php Object Generator (v3.0e) - Open Source PHP Code Generator XRefresh Create a Custom Toolbar | Conduit apinstein's iphp at master - GitHub php-excel - Project Hosting on Google Code For many modern companies Excel is still the main tool to use when it comes to analysis or reports. php-excel aims to be the most simple and lightweight approach to convert a matrix-like, two-dimensional array from PHP to Microsoft Excel. Here are some examples: Create a quick export from a database table into Excel Compile some statistical records with a few calculations and deliver the result in an Excel worksheet Gather the items off your (web-based) todo list, put them in a worksheet and use it as a foundation for some more statistics magic. However, this library does not sport many features, which would be possible: Creating functions, styling cells etc. Upcoming version 1.2 Version 1.2 will be a complete rework and restructuring of the library. Version 1.1 There is an all new version out which addresses several issues from the bugtracker. MD5 checksum version 1.1 (php-excel-v1.1-20090910.zip): DDC1F41860E4BAF60941108197649BD2 Version 1 Generating excel from php really bugs me.