SELECT     B.Price AS RestPrice, Books.BKey, left(Books.Name, 255 ) as [name], 
Books.Price, Books.Pack
FROM         Books LEFT OUTER 
JOIN
   (SELECT     BKey, Price
FROM         Balance
where pointid=?)  B ON Books.BKey = B.BKey

SELECT     BKey, Price into #tb
FROM         Balance
where pointid=?

SELECT     B.Price AS RestPrice, Books.BKey, left(Books.Name, 255 ) as [name], 
Books.Price, Books.Pack
FROM         Books LEFT OUTER 
JOIN
#tb             B ON Books.BKey = B.BKey

SELECT     Balance.Price AS RestPrice, Books.BKey, LEFT(Books.Name, 
 255 ) AS name, Books.Price, Books.Pack
FROM         Books LEFT 
OUTER 
JOIN
                      Balance ON Books.BKey = Balance.BKey
WHERE     (Balance.PointID = ?)