from T_ForkliftDTL td inner join T_Forklifthdr th on td.pid=th.pid inner join T_Forkliftinfo ti on th.forkliftcode=ti.forkliftcode inner join systype st on td.usetype=st.typenumber COLLATE Chinese_PRC ...