表t1
Foreign Key:ou
外键 表t3 ->plu
字段Org,plu表t2
Foreign Key:ou
字段Trf,Ins表t3
字段cde 连合查询plu,Org,trf,ins,cde,其中条件plu=(208963,208964,208965,208966,208967,208968,208969)这些值,代码怎么写?
Foreign Key:ou
外键 表t3 ->plu
字段Org,plu表t2
Foreign Key:ou
字段Trf,Ins表t3
字段cde 连合查询plu,Org,trf,ins,cde,其中条件plu=(208963,208964,208965,208966,208967,208968,208969)这些值,代码怎么写?
FROM t1 JOIN t2 USING(t1和t2的主外键列名)
JOIN t3 USING(主外键列名)
WHERE t1.Plu IN (208963,208964,208965,208966,208967,208968,208969);
FROM t1, t2, t3
WHERE t1.ou=t2.ou AND t1.plu = t3.plu AND t1.plu IN (208963,208964,208965,208966,208967,208968,208969)