I lied.

Syntax I'd got was for execution through ODBC. So how'd you do it then?

I'm now working round it by looping through with an outer cursor which is open/closed 20 or so times. After each row is fetched I'm building another SQL Cursor based on each row's results. This inner sqwelly goes off and does it's thing.

Not nice but it works.

Basically what I want to do is PREPARE two lots of SQL with ? placeholders. One of them will be an outer cursor which fetch results into variable which in turn are used within the 2nd SQL. If I could prep the sqwelly up fromt it'd be a little quicker and muchos easier to read.