你好!
你需要把SQL 改为如下:
SELECT DSINSTANCE.INSTID,
LASTOPERATER,
DSITEM.INSTID,
CREDNAME,
ITEMID,
DSPAGE.ITEMID
FROM DIGITALSCAN.DSINSTANCE, DIGITALSCAN.DSITEM, DIGITALSCAN.DSPAGE
JOIN DSINSTANCE.INSTID
ON DSINSTANCE.INSTID = DSITEM.INSTID AND DSITEM.ITEMID = DSPAGE.ITEMID
ORDER BY DSINSTANCE.INSTID;
绝对是正确答案!
请您采纳!