MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:fsb Date:January 21 2010 3:15pm
Subject:Re: Quick help with Insert
View as plain text  
that's exactly how i do it.


On 1/19/10 3:57 PM, "Intell! Soft" <h.bacik@stripped> wrote:

> 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