• What any means is that the FROM clause is just listing the tables and not the relationships between them and relies on the WHERE clause for its joining criteria.

    Old Style

    Select

    A.somecol,

    B.othercol

    FROM

    A,

    B

    WHERE

    A.foreignkey = B.primaryKey

    AND

    A.somecol = 'somevalue'

    New Style

    Select

    A.somecol,

    B.othercol

    FROM

    A

    INNER JOIN

    B on B.primaryKey = A.foreignKey

    WHERE

    A.somecol = 'somevalue'