[thelist] php query

Kae Verens kverens at contactjuggling.org
Thu Feb 20 06:02:03 CST 2003


Jason Handby wrote:
> Liam wrote:
>
>>Something like the following should suffice in MySQL
>>
>>select table2.col_name from table1, table2 where table2.reference_id =
>>table1.id

> Can I be really picky and recommend that you write it as
>
>   select table2.col_name from table1 INNER JOIN table2 ON
> table2.reference_id=table1.id
>
> instead? Writing your joins in ANSI-style is a good syntactic habit to get
> into, and it can make complex multi-join queries much more readable.

Do you have a URL which explains the ANSI style clearly? I tend to use
the former method myself as well, and would like to understand the
differences

--
Kae Verens               _______\_   webworks.ie
work: www.webworks.ie       _____\\__   webhosts
play: www.contactjuggling.org  ___\\\___  design
kae:  kverens.contactjuggling.org _\\\\____ code




More information about the thelist mailing list