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