Posted by Rik on 10/19/06 22:43

Rik wrote:
> SELECT
> x.field1, y.field2
> FROM table1 x
> LEFT JOIN table2 y
> ON x.field2 = y.field1


Euhm, switch around tablenames offcourse:
SELECT
x.field1, y.field2
FROM table2 x
LEFT JOIN table1 y
ON x.field2 = y.field1

Grtz,
--
Rik Wasmus

• Next in forum: Re: PHP Coding question
• Prev in forum: Re: Linking tables to display data?
• Thread view: Re: Linking tables to display data?

[Reply to this message]