Ytukyg

I have tables as follows.

SAMPLE DATA



TABLE ARK

ID DOMAIN       USERNAME PASSWORD    USERID

1  arklar.com   arkalar  sdfdsfsdf   1

2  arklars.com  arkalars  sdfdsfsdf   2



TABLE MAIL

ID DOMAIN       ARKID USERNAME  PASSWORD    USERID

2  arklar.com   1     mailuser  adsasadas   1

3  arklars.com  1     mailusers adsasadas   2



TABLE ARKSUB

ID DOMAIN        ARKID IP          TYPE    USERID

1  arksub.com    1     127.0.0.1   addon   1

1  arksub2.com   1     127.0.0.1   addon   1



TABLE EXIST

ID    DOMAIN         EX

400   arksub2.com    ok

500   arklars.com    ok





SQL QUERY OUT;

ID DOMAIN       TABLEMAIL.USER

.  arklar.com   mailuser

.  arksub.com   mailuser

No records from "TABLE EXIST" How should I write a query?

SELECT    *

FROM      ark    AS h

LEFT JOIN arksub AS a

ON        h.userid=a.userid

LEFT JOIN mail AS e

ON        h.userid=e.userid

AND       h.userid=e.userid

WHERE     NOT exist

          (

                 select 1

                 FROM   exist

                 WHERE  exist.domain = ark.domain)

OR

          (

                 SELECT 1

                 FROM   exist

                 WHERE  exist.domain = arksub.domain)