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 r...@rodonnell.ie
