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 !
