List:General Discussion« Previous MessageNext Message »
From:Roger Baklund Date:November 20 2003 2:23pm
Subject:Re: LEFT JOIN problem
View as plain text  
* Rory McKinley
[...]
> SELECT a.line_number, a.category_value, IFNULL(b.parameter_trigger, 0)
> FROM DB1.Table 1 AS a LEFT JOIN DB2.Table 2 AS b ON
> a.category_name = b.parameter_value
> WHERE a.line_type = 13 AND b.parameter_ID = 13
>
> The only problem is that the query only returns the first two
> records and not the third record - contrary to my expectations. I
> am using MySQL 4.0.15-standard together with PHPMyAdmin 2.5.3.
>
> Does anybody know what I am doing wrong?

You have a criteria on the B table in the WHERE clause. Move it to the ON
clause:

SELECT ... AS b ON
    a.category_name = b.parameter_value AND
    b.parameter_ID = 13
  WHERE a.line_type = 13

--
Roger

Thread
LEFT JOIN problemRory McKinley20 Nov
  • Re: LEFT JOIN problemRoger Baklund20 Nov
    • [SOLVED]Re: LEFT JOIN problemNobody20 Nov
    • Re: [SOLVED]Re: LEFT JOIN problemMartijn Tonies20 Nov
      • Re: [SOLVED]Re: LEFT JOIN problemRoger Baklund20 Nov
        • Re: [SOLVED]Re: LEFT JOIN problemMartijn Tonies20 Nov
          • Re: [SOLVED]Re: LEFT JOIN problemRoger Baklund20 Nov
        • Re: [SOLVED]Re: LEFT JOIN problemMartijn Tonies20 Nov