News About
SQL Learning:
Introduction
SQL Managing Databases
SQL Database Content
SQL Create Database
SQL Listing Databases
SQL Use Database
SQL Alter Database
SQL Drop Database
SQL Managing Tables
SQL Tables Content
SQL Create Table
SQL Table Column Types
SQL Table Primary Key
SQL Auto Increment
SQL Unique Columns
SQL Table Constraints
SQL Drop Table
SQL Alter Table with ADD
SQL Alter Table with MODIFY
SQL Alter Table with DEFAULT
SQL Alter Table with DROP
SQL Managing Indexes
SQL Why Table Indexes
SQL Create Table with Indexes
SQL Create Index on Table
SQL Alter Table Indexes
SQL Drop Table Indexes
SQL Rename Table Index
SQL Data Modification
SQL Insert Table Data
SQL Update Table Data
SQL Delete Table Data
SQL SELECT
SQL SELECT Overview
SQL Column Selection & Design
SQL Column Computation
SQL FROM tables
SQL WHERE
SQL WHERE Statement
SQL Where Comparison
SQL AND, OR, NOT
SQL BETWEEN, NOT BETWEEN
SQL IN, NOT IN
SQL LIKE, NOT LIKE
SQL NULL values & COALESCE
SQL Operator Precedence
SQL Sorting and grouping
SQL ORDER BY
SQL DISTINCT
SQL GROUP BY
SQL HAVING
SQL Functions
SQL Aggregate Functions
SQL String Functions
SQL Date and Time Functions
SQL Numeric Functions
SQL JOIN Tables
SQL JOIN Basics
SQL JOIN with FROM/WHERE
SQL INNER JOIN
SQL CROSS JOIN
SQL NATURAL JOIN
SQL LEFT JOIN
SQL RIGHT JOIN
SQL FULL JOIN
SQL JOIN with USING
SQL JOIN ON/WHERE Operators
SQL JOIN Multiple Tables
SQL UNION
SQL INTERSECT
SQL MINUS
SQL VIEW
Review w3processing.com on alexa.com

SQL JOIN ON/WHERE Operators.

Join tables with other operators in the WHERE or ON keywords.

  • To link data from multiple tables together, you can use other operators than just equality (=) between the columns in the tables.These operators are:
    Symbol Meaning
    > greater than
    >= greater than or equal to
    < less than
    <= less than or equal to
    <> not equal to
    This Example 1 uses JOIN and ON with operator < (less than) to connect together data from two tables:
    SQL server, MySQL, Oracle, PostgreSQL :
    Select   a.US_STATE_CD , ADDR_LINE "Address", 
   CITY , u.US_STATE_CD
 from ADDRESSES a  JOIN US_STATES u
 ON a.US_STATE_CD < u.US_STATE_CD
 and u.US_STATE_CD LIKE 'C%'
 order by a.US_STATE_CD, u.US_STATE_CD
    The result should be:
    us_state_cd Address city us_state_cd
    AR 3009 Table Rock Road Biglerville Alleene CA
    AR 3009 Table Rock Road Biglerville Alleene CA
    AR 3009 Table Rock Road Biglerville Alleene CO
    AR 3009 Table Rock Road Biglerville Alleene CO
    AR 3009 Table Rock Road Biglerville Alleene CT
    AR 3009 Table Rock Road Biglerville Alleene CT
    CA 3871 San Antonio Drive Indio Agoura Hills CO
    CA 5325 N Sheridan Road Aguanga CO
    CA 5325 N Sheridan Road Aguanga CT
    CA 3871 San Antonio Drive Indio Agoura Hills CT
    This Example 2 uses WHERE with operator > (greater than) to connect together data from two tables:
    SQL server, MySQL, Oracle, PostgreSQL :
    Select   a.US_STATE_CD , ADDR_LINE "Address", 
   CITY , u.US_STATE_CD
 from ADDRESSES a , US_STATES u
 WHERE a.US_STATE_CD > u.US_STATE_CD
 and u.US_STATE_CD LIKE 'C%'
 order by a.US_STATE_CD, u.US_STATE_CD
    The result should be:
    us_state_cd Address city us_state_cd
    FL 4415 Metro Parkway Fort Myers Calford CA
    FL 9468 Wandering Way Columbia Alachua CA
    FL 4415 Metro Parkway Fort Myers Calford CO
    FL 9468 Wandering Way Columbia Alachua CO
    FL 4415 Metro Parkway Fort Myers Calford CT
    FL 9468 Wandering Way Columbia Alachua CT
    MA 1900 Manakin Road Manakin Sabot Abington CA
    MA 1900 Manakin Road Manakin Sabot Abington CA
    MA 1900 Manakin Road Manakin Sabot Abington CO
    MA 1900 Manakin Road Manakin Sabot Abington CO
    MA 1900 Manakin Road Manakin Sabot Abington CT
    MA 1900 Manakin Road Manakin Sabot Abington CT
    NJ 195 Cedar Avenue Staten Island Bordentown CA
    NJ 195 Cedar Avenue Staten Island Bordentown CO
    NJ 195 Cedar Avenue Staten Island Bordentown CT
    NY 2581 Richmond Terrace Staten Island Mappleton CA
    NY 2581 Richmond Terrace Staten Island Mappleton CO
    NY 2581 Richmond Terrace Staten Island Mappleton CT
Prev. in menu Next in menu
Prev. in menu Next in menu
© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the correctness in the pages or source codes.
The risk of using this web-site pages or any program codes from this website is entirely at the individual user.