Re: Using LOOP and cursor

[Peter Brawley]

> There is really nothing to join the tables on

If that's the case, no cursor will do the job either.

> table1 number being between table2 number_column1 and number_column2 is the only identifier

Then the join clause would be ... on table1.number between table2.column1 and table2.column2?

For us to understand the requirement, please write that query in English rather than fractured SQL, and please post the Show Create Table result for each table.