alles was nit in Tabelle x in tabelle z schreiben

[Uwe Driessen]

On Behalf Of HMeissner at dgverlag.de
> Im Auftrag von Uwe Driessen
> 
> insert into ispcp.domain_aliasses (`domain_id`, `alias_name`, `alias_status`,
> 						`alias_mount`, `alias_ip_id`,
> `url_forward`)
>         select t2.do_id_neu, t2.domain_name, "toadd", t2.domain_name, 1, "no"
>         from openprovide.op_domains t2
>              join ispcp.domain t3 on t2.domain_name = t3.domain_name
>         where t2.domain_name
> 		not EXISTS (select 1 from ispcp.domain t4 where t2.domain_name =
> t4.domain_name  )
>             and  (select 1 from openprovide.diehl_domain t5
>                     where t5.name = t2.domain_name and
>                    (t5.domainip = "IP"
> 				or t5.domainip = "mail");
> 
> oder
> 
> insert into ispcp.domain_aliasses (`domain_id`, `alias_name`, `alias_status`,
> `alias_mount`, `alias_ip_id`, `url_forward`)
>         select t2.do_id_neu, t2.domain_name, "toadd", t2.domain_name, 1, "no"
>         from openprovide.op_domains t2
>                 join ispcp.domain t3 on t2.domain_name = t3.domain_name
>                 join openprovide.diehl_domain t5 on t2.domain_name = t5.name
>         where t2.domain_name NOT EXISTS  (select 1 from ispcp.domain t4 where
> t2.domain_name = t4.domain_name  )
>                         and   (t5.domainip = "IP" or t5.domainip = "mail");
> 
> 
> mögen mich nicht
> 
> ich bekomme immer den Fehler
> 
> 1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei
> 'EXISTS  (select 1 from ispcp.domain t4 where t2.domain_name = t4.domain_name  ) ' in
> Zeile 6
> 
> 
> kein join auf T4 .....

Soll heißen ich hab einen join  vergessen oder ich hab einen join zuviel?

Zu zeit komplett auf dem Schlauch stehe.  


> 
> 
> Grüße
> h1
> 
> 
> 


Mit freundlichen Grüßen

Drießen

-- 
Software & Computer
Uwe Drießen
Lembergstraße 33
67824 Feilbingert
Tel.: +49 06708 / 660045   Fax: +49 06708 / 661397