La LEFT JOIN deve essere scritta con la clausola ON
codice:
codice:
SELECT
t1.email, t1.user_id, t1.telefono, t1.mobile, t2.email, t2.telefono, t2.mobile
FROM
utenti t1,
LEFT JOIN struttura t2 ON t1.user_id = t2.user
WHERE (
t1.email IN (
'email1@email.it',
'email2@email.it',
'email3@email.it'
)
OR
t2.email IN (
'email1@email.it',
'email2@email.it',
'email3@email.it'
)
)
ORDER BY
t1.email, t2.email
Oppure prova questo (non testato)
codice:
codice:
select * from
(
select t1.email as e, t1.user_id as u, t1.telefono as t, t1.mobile as m
from utenti
union
select t2.email as e, t2.user as u, t2.telefono as t, t2.mobile as m
from struttura
)
where e in (
'email1@email.it',
'email2@email.it',
'email3@email.it'
)