Re: Question about joining tables
From: Roy Hann <specially_at_processed.almost.meat>
Date: Fri, 29 Feb 2008 10:25:04 -0000
Message-ID: <ZumdnXvw3v8cQFraRVnyuQA_at_pipex.net>
Date: Fri, 29 Feb 2008 10:25:04 -0000
Message-ID: <ZumdnXvw3v8cQFraRVnyuQA_at_pipex.net>
"Knowledgy" <atlanta business intelligence consultants> wrote in message
news:feOdnSoJQdYv1VranZ2dnUVZ_q2hnZ2d_at_comcast.com...
> SELECT *
> FROM property p LEFT OUTER JOIN property_image pi
> ON p.property_id = pi.property_id
>
> Use the newer ansi join syntax. DBMS systems are deprecating
> the older style join you're using
Deprecating it? Really? I'd not heard that, and I find it hard to believe now I have.
Roy Received on Fri Feb 29 2008 - 11:25:04 CET