List:General Discussion« Previous MessageNext Message »
From:Intell! Soft Date:January 19 2010 8:57pm
Subject: Re: Quick help with Insert
View as plain text  
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:carlos.proal@stripped]
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:intellisoft@stripped]
> 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 !
>
>
>
>
>
>
>
>
>



Thread
Re: Quick help with InsertIntell! Soft19 Jan
  • Re: Quick help with InsertCarlos Proal19 Jan
    • Re: Quick help with InsertIntell! Soft19 Jan
      • Re: Quick help with Insertfsb21 Jan