mysql联表查询语句示例

mysql联表查询语句示例

示例："select a.trade_no,a.add_time,a.amount,a.status,b.nickname from pigcms_user_money_withdrawal    as  a join    pigcms_user as  b on  a.user_id=b.uid join    pigcms_user as  con  c.user_id=b.uidwhere a.user_id='".$uid."' order by add_time desc limit ".($page1*10-10).",10";