Re: 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 ON main.id =
> other.id_main
> LEFT OUTER JOIN other AS other2 ON main.id =
> other2.id_main
> WHERE
> other.type = 'type_one'
> AND other2.type = 'type_two';
> ==

You can alias a table to join it to itself. I'm not sure whether that
answers your question.

SELECT t1.field FROM table AS t1 JOIN table as t2 on (cond)

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>