[thelist] SQL: looking for resources, have one question

[Chris W. Parker]

> -----Original Message-----
> From: Chris Blessing [mailto:webguy at mail.rit.edu]
>
> For your query, try this inner join:
>
> SELECT a.manufacturerID, a.ID
>   FROM products a, manufacturers b
>     WHERE a.manufacturerID = b.id
>   ORDER BY a.manufacturerID

this one worked.

> The
> current SQL-92
> standard for inner joins (preferrably) is used in the FROM
> clause as such:
>
> SELECT a.manufacturerID, a.ID
>   FROM products a
>     INNER JOIN manufacturers b
>     ON a.manufacturerID = b.id
>   ORDER BY a.manufacturerID

this one didn't. which is probably what is expected.


thanks for your help chris.


chris.

p.s. hey look, we have the same name!! hahaha! isn't that SOOOOO wierd?