SELECT c.equip_no, e.equip_nm, c.yc_no, y.yc_nm from (cur_data as c INNER join equip as e on e.equip_no=c.equip_no) INNER join ycp as y on y.equip_no=c.equip_no and y.yc_no=c.yc_no group by c.equip_no, c.yc_no, e.equip_nm, y.yc_nm;
Monday, July 30, 2012
Access Join多个表
Sunday, July 22, 2012
MySQL随机生成ID
随机生成ID
update www_image set user_id=(select round(round(rand(),4)*30000));
Subscribe to:
Posts (Atom)