Essential Books

Select rows from multiple tables

suggest change 
SELECT *
FROM
    table1,
    table2
SELECT
    table1.column1,
    table1.column2,
    table2.column1
FROM
    table1,
    table2

This is called cross product in SQL it is same as cross product in sets

These statements return the selected columns from multiple tables in one query.

There is no specific relationship between the columns returned from each table.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SELECT:
* SELECT
* Using the wildcard character to select all columns in a query.
* SELECT Using Column Aliases
* Select Individual Columns
* Selecting specified number of records
* Selecting with Condition
* Selecting with CASE
* Select columns which are named after reserved keywords
* Selecting with table alias
* Selecting with more than 1 condition.
* Selecting with Aggregate functions
* Get aggregated result for row groups
* Selection with sorted Results
* Selecting without Locking the table
* Select with condition of multiple values from column
* Select distinct unique values only
* Selecting with null
* Select rows from multiple tables
Table Of Contents