[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