SQL语句:
$sql = "SELECT o.*,g.*,u.name AS uname,v.name AS vname "
."FROM at_order o,at_user u,at_user v,at_goods g"
."WHERE (u.id = o.uid) AND (v.id = o.vid) AND (g.id = o.gid)";
功能描述:同时获取订单表的商品、买家和卖家信息
注意:对同一张表使用不同的别名即可多次操作同一张表
SQL语句:
$sql = "SELECT o.*,g.*,u.name AS uname,v.name AS vname "
."FROM at_order o,at_user u,at_user v,at_goods g"
."WHERE (u.id = o.uid) AND (v.id = o.vid) AND (g.id = o.gid)";
功能描述:同时获取订单表的商品、买家和卖家信息
注意:对同一张表使用不同的别名即可多次操作同一张表