Re: insert using subquery
From: bill <william_at_TechServSys.com>
Date: Sat, 13 Aug 2016 07:49:41 -0400
Message-ID: <non1go$rif$2_at_gioia.aioe.org>
Date: Sat, 13 Aug 2016 07:49:41 -0400
Message-ID: <non1go$rif$2_at_gioia.aioe.org>
>> Try:
>> INSERT INTO `pendingInsBillings`(`transNum`)
>> (SELECT `transNum` FROM `transactions`
>> where
>> `description` LIKE 'Quality Reporting%')
>>
>>
>
> Because the keyword VAULES is not used in the third form that is
> shown here:
> http://dev.mysql.com/doc/refman/5.7/en/insert.html
>
>
That worked, sorta like magic.
Thanks Wizard Luuk
bill Received on Sat Aug 13 2016 - 13:49:41 CEST