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:[EMAIL PROTECTED] > Sent: Wednesday, September 05, 2007 10:39 AM > To: mysql@lists.mysql.com > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
