联动查询的问题

select A.id,title,city,address,po1,po2, B.web from A,B where A.id=B.id and A.id in (1320,1497,1555,1658,1918,1952,1992,2009,2022,2050,2088,2097,2126,2158,2160,2196,2203,2267,2297,2306,2329,2356,2373,2391,2407,2602,2730,2952,3012,3019,3024,3095,3105,3138,3167,3210,3241,3261,3267,3300,3302,3341,3411,3418,3468,3493,3535,3556,3626,3680,3822,3824,3861,3915,3990,4010,4012,4185,4246,4303,4346,4349,4374,4404,4419,4420,4429,4460,4462,4485,4512,4527,4535,4536,4547,4575,4585,4607,4609,4610,4634,4636,5190,5192,5232,5282,5611,5662,5671,5685,5792,5801,5814,6005,6009,6025,6105,6108,6115,6161,6168,6172,6196,6197,6236,6240,6254,6359,6363,6401,6413,6506,6542,6598,6612,6627,6670,6795,6848,6873,6900,6934,6962,6968,6969,6992,7072,7088,7094,7120,7142,7147,7217,7222,7253,7339,7377,7423,7439,7501,7503,7688,7706,7714,7850,7878,7881,7957,8000,8085,8169,8183,8226,8304,8308)  

解决方案 »

  1.   

    select A.id,A.title,A.city,A.address,A.po1,A.po2, B.web 
    from A,B where A.id=B.id and 
    A.id in (1320,1497,1555,1658,1918,1952,1992,2009,2022,2050,2088,2097,2126,2158,2160,2196,2203,2267,2297,2306,2329,2356,2373,2391,2407,2602,2730,2952,3012,3019,3024,3095,3105,3138,3167,3210,3241,3261,3267,3300,3302,3341,3411,3418,3468,3493,3535,3556,3626,3680,3822,3824,3861,3915,3990,4010,4012,4185,4246,4303,4346,4349,4374,4404,4419,4420,4429,4460,4462,4485,4512,4527,4535,4536,4547,4575,4585,4607,4609,4610,4634,4636,5190,5192,5232,5282,5611,5662,5671,5685,5792,5801,5814,6005,6009,6025,6105,6108,6115,6161,6168,6172,6196,6197,6236,6240,6254,6359,6363,6401,6413,6506,6542,6598,6612,6627,6670,6795,6848,6873,6900,6934,6962,6968,6969,6992,7072,7088,7094,7120,7142,7147,7217,7222,7253,7339,7377,7423,7439,7501,7503,7688,7706,7714,7850,7878,7881,7957,8000,8085,8169,8183,8226,8304,8308)