摘要:
以vendor 为例, 用到五张SELECT * FROM TMODF WHERE FAUNA LIKE 'T077K%'SELECT * FROM TMODO WHERE FAUNA LIKE 'T077K%'select * from TMODO OINNER JOIN TMODG G ON(O.FAUNA=G.FAUNA AND O.GGRUP =G.GGRUP)INNER JOIN TMODP P ON(O.FAUNA=P.FAUNA AND O.MODIF=P.MODIF)WHERE G.FAUNA LIKE 'T077K-FAUSA%' 阅读全文