Indulge me. I just put the Poor Mans Sql formatter plug-in in my NotePad++ so i'll post for you.
It's available in the plug-in manager of the new version of Notepad++.
ccla, as you can see the code tags and formatting are very important for readability.
Code:
SELECT Lens.LensID
,Company.CompanyName & " " & LensMount.LensMountName & " " & Lens.[Model] AS LensByCompanyAndModel
,Lens.Model
,Lens.CompanyID
,Lens.Modifier
,Lens.SerialNumber
,Lens.LensMountID
,Lens.ApertureIncrements
,Lens.ApertureFast
,Lens.ApertureSlow
,Lens.FocalLengthShort
,Lens.ThreadSizemm
,Lens.Zoom
,Lens.VariableAperture
,Lens.FocalLengthLong
,Lens.ApertureFastLong
,Company.CompanyName
,LensMount.LensMountName
FROM LensMount
INNER JOIN (
Company INNER JOIN Lens ON Company.ID = Lens.[CompanyID]
) ON LensMount.[ID] = Lens.LensMountID
WHERE Lens.LensMountID IN (
SELECT CameraToDirectMount.MountID
FROM CameraToDirectMount
WHERE CameraToDirectMount.CameraID = 2
)
ORDER BY Company.CompanyName & " " & LensMount.LensMountName & " " & Lens.[Model];
Code:
SELECT Lens.LensID
,Company.CompanyName & " " & LensMount.LensMountName & " " & Lens.[Model] AS LensByCompanyAndModel
,Lens.Model
,Lens.CompanyID
,Lens.Modifier
,Lens.SerialNumber
,Lens.LensMountID
,Lens.ApertureIncrements
,Lens.ApertureFast
,Lens.ApertureSlow
,Lens.FocalLengthShort
,Lens.ThreadSizemm
,Lens.Zoom
,Lens.VariableAperture
,Lens.FocalLengthLong
,Lens.ApertureFastLong
,Company.CompanyName
,LensMount.LensMountName
FROM LensMount
INNER JOIN (
Company INNER JOIN Lens ON Company.ID = Lens.[CompanyID]
) ON LensMount.[ID] = Lens.LensMountID
WHERE Lens.LensMountID IN (
SELECT CameraToDirectMount.MountID
FROM CameraToDirectMount
WHERE CameraToDirectMount.CameraID = 2
UNION
SELECT LensAccessory.LensMountToID
FROM LensAccessory
WHERE LensAccessory.ID = 8
)
ORDER BY Company.CompanyName & " " & LensMount.LensMountName & " " & Lens.[Model];