Hi All,
I have a question regarding multiple inserts.
The following function inserts for each country found in country table, values into merchant_buyer_country.
Thanks guys!! that worked!:)
Michael Adler <[EMAIL PROTECTED]> wrote:
On Mon, Dec 13, 2004 at 08:28:39AM -0800, sarlav kumar wrote:> INSERT into merchant_buyer_country (merchant_id,country,enabled,group_id) values (1203, > (SELECT code FROM country WHERE send IS NOT NULL OR receive IS NOT NULL),
On Mon, Dec 13, 2004 at 08:28:39 -0800,
sarlav kumar <[EMAIL PROTECTED]> wrote:
>
> Is there a way to write the INSERT as follows?
>
> INSERT into merchant_buyer_country (merchant_id,country,enabled,group_id)
> values (1203,
> (SELECT code FROM country WHERE send IS NOT NULL OR receive IS N
