如何使用游标编写select with join

DECLARE @cursor CURSOR FOR
SELECT column1, column2
FROM table1
JOIN table2 ON table1.column = table2.column;

OPEN @cursor;

DECLARE @column1 datatype, @column2 datatype;

FETCH NEXT FROM @cursor INTO @column1, @column2;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在这里处理数据
    PRINT @column1;
    PRINT @column2;

    -- 获取下一行数据
    FETCH NEXT FROM @cursor INTO @column1, @column2;
END

CLOSE @cursor;

DEALLOCATE @cursor;