Re: [SQL] Multiple outer join on same table

Marco Lazzeri <[EMAIL PROTECTED]> writes: > Hi! > I'm searching a better (quicker) way to retrieve data as I used to do > using the following query... > > == > > SELECT main.codice, >other.value AS value_one, >other.value AS value_two > FROM main > LEFT OUTER JOIN other

[SQL] Multiple outer join on same table

Hi! I'm searching a better (quicker) way to retrieve data as I used to do using the following query... == SELECT main.codice, other.value AS value_one, other.value AS value_two FROM main LEFT OUTER JOIN otherON main.id = other.id_main LEFT

Re: [SQL] Multiple outer join on same table

On ÐÐÐ, 2004-02-09 at 19:12 +0100, Marco Lazzeri wrote: > Hi! > I'm searching a better (quicker) way to retrieve data as I used to do > using the following query... > > == > SELECT > main.codice, > other.value AS value_one, > other.value AS value_two > FROM main LEFT OUTER JOIN other