SQL Insert Into - Part Deux

[AlbertoD]

@Jeff_Tullin

What do you actually want to do here?

You need to read his other thread. He only posted the select part of the query

SQL Copy Row Data

I’ve been wrestling for a full day now trying to copy all data (except primary key pKey) from CasesListboxColumn = 4 data (see database pic below) to CasesListboxColumn = 2 data (present, but not shown in the image below). I’ve tried a bunch of INSERT TO variations but without any luck. On a few of them, I got a SQL error, while the others ran without error but without any data transfer. Help me, Obi Wan … you’re my last hope! Xojo 2016 r1 Windows 10 [SampleDBpic2]