On 15/10/2019 15:01, stan wrote:
> Thanks, as you can see from my SOLVED reply, I go that part figured out.
> Now I am trying to figure out how to complete this. The SELECT returns more
> than 1 row, and when I put that in the VALUES clause this does not work.
Please reply to the list, rather than to me - reply-all should do the
trick. :-)
You're using cross-joins, which returns the cartesian product of the
tables concerned, without any WHERE clause.... so if the tables are big
you'll return a LOT of data.
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie