[MySQL] WHERE IN and IF NOT EXISTS

[badaze]

La LEFT JOIN deve essere scritta con la clausola ON
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:

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'
         )