Improvable Query?

[Cined]

Hi there,



I have the following query that (in my opinion) is far too long than it needs to be and contains statements which can be merged. The trouble is, I don't know how to do it

Is there any way I can improve on this to make it 'better'?



Also, currently the order of the fields being selected is Date, Time, Buyer Name, Seller Name, Property Address, Staff Members Name. Is there anyway I can change the order of this?

Thanks.

[ssanfu]

Ummmm, it looks to me to be too short.

Did you mean to add the SQL of the query??? It would be very helpful..