List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 5 2007 3:37pm
Subject:RE: Left join problem
View as plain text  
Which table is bladref in?

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com


> -----Original Message-----
> From: Kaj Schermer Didriksen [mailto:kaj@stripped]
> Sent: Wednesday, September 05, 2007 10:39 AM
> To: mysql@stripped
> Subject: Left join problem
>
> Hi
> two tables gi_t and gi
>
> gi_t holds 5 records. gi holds ca. 1500.
>
> I need all from gi for each in gi_t ie LEFT JOIN!!!
> but this:
> SELECT gi.id AS id, overskrift,gidata FROM gi_t LEFT JOIN gi ON
> gi_t.id=gi.gitref WHERE bladref=137
> gives the same as
> SELECT gi.id AS id, overskrift,gidata FROM gi_t ,gi WHERE
> gi_t.id=gi.gitref AND bladref=137
>
> I want 5 records (3 ok, and 2 NULL) and I get 3. the 3 that has a
> relation in gi
>
> why?
> Regards
> Kaj Schermer Didriksen
>



Thread
Left join problemKaj Schermer Didriksen5 Sep
  • RE: Left join problemJerry Schwartz5 Sep
  • Re: Left join problemMartijn Tonies5 Sep