that's exactly how i do it.
On 1/19/10 3:57 PM, "Intell! Soft" <h.ba...@intelli-soft.at> 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.pr...@gmail.com] > 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:intellis...@fachoptiker.net] >> 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/mysql?unsub=arch...@jab.org
