Wednesday, 13 July 2011

INNER JOIN in MYSQL

SELECT * FROM shipping_name as sn INNER JOIN region_shipping as rs ON (rs.ship_id=sn.id) where rs.reg1!='' and rs.reg_1!='' or rs.reg2!='' and rs.reg_2!='' or rs.reg3!='' and rs.reg_3!='' or rs.reg4!='' and rs.reg_4!='' or rs.reg5!='' and rs.reg_5!='' or rs.reg6!='' and rs.reg_6!='' and sn.ship_price!=''

No comments:

Post a Comment