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'; == Thanks, Marco ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org