Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table has
> a NULL value in
Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table has
> a NULL value in
On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> He is doing an inner join, you are doing a left join, they (potentialy)
> do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value in the condition are left out, right?
>
Steve Ruby wrote:
>
> Christian Hammers wrote:
> >
> > Hello list
> >
> > While browsing old sources by a former employee I realised that he always
> > did comma seperated joins and then a "where"
> > FROM
> > tablea a, tableb b, tablec c
> > WHERE
> > a.id=b.i
Christian Hammers wrote:
>
> Hello list
>
> While browsing old sources by a former employee I realised that he always
> did comma seperated joins and then a "where"
> FROM
> tablea a, tableb b, tablec c
> WHERE
> a.id=b.id and b.nr=c.nr
> whereas I learned to
In the last episode (Mar 08), Christian Hammers said:
> While browsing old sources by a former employee I realised that he
> always did comma seperated joins and then a "where"
> FROM
> tablea a, tableb b, tablec c
> WHERE
> a.id=b.id and b.nr=c.nr
> whereas I l
