俺的地盘,神做主!

SQL中多表跨库查询!

上一篇 / 下一篇  2008-04-15 14:32:43

SELECT b.chargeitemtypename AS name, a.*, c.priceunit AS Expr1
FROM GNET_MIS_BOOKING_PRICE a INNER JOIN
      NewBoss.dbo.dd_sv_chargeitemtype b ON
      a.PRICE_ID = b.chargeitemtypeid INNER JOIN
      NewBoss.dbo.dd_sv_chargetype c ON b.chargetypeid = c.chargetypeid
WHERE (a.PRICE_GROUP_ID = 11)
ORDER BY a.PRICE_ID

 


TAG:

 

评分:0

我来说两句

Open Toolbar