select * from pub_gd_cart a inner join pub_gd_goodsinfo b on a.fmailcode = b.fmailcode where a.fmailcode = 'ma20180404001'
用 INNER JOIN试试
