insert using subquery
From: bill <william_at_TechServSys.com>
Date: Sat, 13 Aug 2016 07:03:32 -0400
Message-ID: <nomuq7$nln$1_at_gioia.aioe.org>
[Quoted] I have a query that works:
Date: Sat, 13 Aug 2016 07:03:32 -0400
Message-ID: <nomuq7$nln$1_at_gioia.aioe.org>
[Quoted] I have a query that works:
[Quoted] [Quoted] SELECT `transNum` FROM `transactions`
where
`description` LIKE 'Quality Reporting%'
now I want to make it a subquery in order to insert transNum into another table
insert into pendingInsBillings (transNum) Values (??)
here (SELECT `transNum` FROM `transactions`
where
`description` LIKE 'Quality Reporting%')
I just can't figure out what to replace the ?? with in the main query in order to get the value of transNum from the subquery.
bill Received on Sat Aug 13 2016 - 13:03:32 CEST