RE: INSERT ... SELECT - A slightly different question

2003-02-20 Thread Kyle Lange
That makes sense. Thank you Tore. Kyle -Original Message- From: Tore Bostrup [mailto:[EMAIL PROTECTED]] Sent: Friday, 21 February 2003 01:12 To: Kyle Lange; [EMAIL PROTECTED] Subject: Re: INSERT ... SELECT - A slightly different question The typical syntax for this would be: INSERT

Re: INSERT ... SELECT - A slightly different question

2003-02-20 Thread Tore Bostrup
The typical syntax for this would be: INSERT INTO phone (personID, phoneNr, email, type) SELECT personID, '1-xxx-xxx-', \N, 'OFF' FROM persons WHERE lastName='' HTH, Tore. - Original Message - From: "Kyle Lange" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, Febru