So when I change the query to this:

SELECT

B.BlockName AS Block,

I.Lot AS Lot,

...

Thank you for the quick reply

The on's should be after the joins, I think it's just how the board is formatting the code. I typically have it indented etc so...