INNER JOIN and , (comma) are equivalent in the absence of a join condition
and "JOIN" is defined to be equivalent to an "INNER JOIN"
Examples:
SELECT * FROM customer AS c,
orders AS o
...
Read more »
3 search results for "northwind"
SQL: some basic JOIN syntax
NorthWind db in MySQL
Microsoft's SQL Server 2000 comes with 2 sample databases, one of which is NORTHWIND a sample accounting database
Below are the table definitions needed to export NorthWind from MS SQL Server 2000 and import NorthWind into MySQL
I have exported out the main table definitions and their data and put them...
Read more »
A few NorthWind MySQL PHP scripts
Note that the dates on the NorthWind data range only across 1 full year, 1997: from July 1996 to May 1998.
Each line of data below comes from 3 files (tables): the orders file, the order-details file, and the customer file. There are also files of employees, products, suppliers,...
Read more »
