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