Hi,

I have a query:
"SELECT dbo.tblDeal2.dealName, dbo.tblDeal2.dealID, " &_
"dbo.tblPlots.plotName, dbo.tblDeal2.reservationFee, " &_
"dbo.tblPlots.particulars, dbo.tblPlots.otherInfo, " &_  
"dbo.tblBasketItems.basketItemID, dbo.tblBasketItems.basketID " &_
"FROM dbo.tblBasketItems INNER JOIN " &_
"dbo.tblPlots ON dbo.tblBasketItems.plotID = dbo.tblPlots.plotID " &_
"CROSS JOIN dbo.tblDeal2 " &_
"WHERE dbo.tblBasketItems.basketID = " & Session("basketID") &_
" AND dbo.tblPlots.dealID = dbo.tblDeal2.dealID"


which returns data like this:

[dealName]      [plotName]      [reservationFee]
  :                 :                 :
  :                 :                 :
[dealName]      [plotName]      [reservationFee]

I would prefer the result to be like this:

[dealName]
      [plotName]      [reservationFee]
          :                  :
          :                  :
      [plotName]      [reservationFee]
[dealName]
      [plotName]      [reservationFee]
          :                  :
          :                  :
      [plotName]      [reservationFee]

... etc.

I have tried GROUPing by dbo.tblDeal2.dealName and dbo.tblDeal2.dealID, 
but to no avail.
My question is 'can I do this in a single query, or will I have to loop 2 
queries?'

Thanks
Dave