查询分店与总部商品价格不同的语句

use issyytv3
go
SELECT a.branch_no,a.item_no  FROM dbo.t_pc_branch_price a,dbo.t_bd_item_info b
WHERE a.sale_price<>b.sale_price AND a.item_no=b.item_no
AND a.branch_no<>’000′