SELECT * FROM StormDesign.dbo.ApprovedMasterFiles AS amf

WHERE amf.DesignHouseTypeId = '67027'


SELECT * FROM ChinchillaData.dbo.Customers AS c

WHERE c.Account = 'AG0025A'


SELECT * FROM ChinchillaData.dbo.HouseTypes AS ht

WHERE ht.CustomerID = 'AG0025A'


SELECT * FROM dbo.JobTrack AS jt

WHERE jt.OrderNo = '193316'


SELECT * FROM dbo.Order_Receipt AS ore

WHERE ore.Account = 'AG0025A'