select top 10 z.* from Order x,Goods y,Dealer z where x.goods_id = y.good_id and y.dealer_id = z.dealer_id and z.dealer_city='上海' order by x.order_time desc
看情况用INNER JOINSELECT TOP 10 * FROM ORDER AS o LEFT JOIN Goods AS g ON o.goods_id = g.good_id LEFT JOIN Dealer AS d ON g.dealer_id = d.dealer_id WHERE d.dealer_city = '上海' ORDER BY o.order_time DESC
from Order x,Goods y,Dealer z
where x.goods_id = y.good_id and y.dealer_id = z.dealer_id
and z.dealer_city='上海'
order by x.order_time desc
TOP 10 *
FROM
ORDER AS o
LEFT JOIN Goods AS g ON o.goods_id = g.good_id
LEFT JOIN Dealer AS d ON g.dealer_id = d.dealer_id
WHERE
d.dealer_city = '上海'
ORDER BY
o.order_time DESC