Thanks! - I found a Insert Into on your tip:
Insert Into Lieferanten (Lieferant)
select distinct
a.lieferant
from artikelstamm a
left join lieferanten b on
a.lieferant = b.lieferant
where
b.lieferant is null
-----Ursprüngliche Nachricht-----
Von: Carlos Proal [mailto:[email protected]]
Bereitgestellt: Dienstag, 19. Jänner 2010 20:15
Bereitgestellt in: gmane.comp.db.mysql.general
Unterhaltung: Quick help with Insert
Betreff: Re: Quick help with Insert
Hi !!
You need a left join and then an insert.
Please read: http://dev.mysql.com/doc/refman/5.1/en/join.html or google
for tutorials on left join
And tell me if you have further questions
Carlos
On 1/19/2010 1:00 PM, Intell! Soft wrote:
> Hey
> Not really quick.... ;> - But nobody knows an answer?
>
> THX
>
>
> -----Ursprüngliche Nachricht-----
> Von: Intell! Soft [mailto:[email protected]]
> Bereitgestellt: Donnerstag, 14. Jänner 2010 17:40
> Bereitgestellt in: gmane.comp.db.mysql.general
> Unterhaltung: Quick help with Insert
> Betreff: Quick help with Insert
>
> Hey
>
> I would need quick help with an Insert statement
> So, I have two tables Table A& Table B
> So, in Table A I have a field called customerID
> The same field I do have in Table B
> So, I want to find out, which customerID from Table A is NOT in Table
B
> and fill the customerID's which are not present in Table B.
>
> Understood? - Hope so
>
> THX !
>
>
>
>
>
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
