Re: Question about joining tables

From: Jan Hidders <hidders_at_gmail.com>
Date: Fri, 29 Feb 2008 04:44:44 -0800 (PST)
Message-ID: <455752ab-ea6b-458d-8acf-aefb724b8eae_at_n75g2000hsh.googlegroups.com>


On 29 feb, 11:25, "Roy Hann" <specia..._at_processed.almost.meat> wrote:
> "Knowledgy" <atlanta business intelligence consultants> wrote in messagenews: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.

Neither can I. So I'm very curious (a) what that exactly means and (b) what evidence there is for this. So John, could you shed some light on this?

  • Jan Hidders
Received on Fri Feb 29 2008 - 13:44:44 CET

Original text of this message