select px.*,pxl.* from product_d_xattributes as px, product_d_xattributes_lang as pxl where px.pid='2' and px.pxid=pxl.xatid and pxl.language='en' and px.is_visible='Yes'.mysql error : Table 'fernando_miraclefruitman.product_d_xattributes' doesn't exist