SELECT `s` . `Id` , `s` . `Abn` , `s` . `AccountId` , `s` . `Active` , `s` . `AddressLine1` , `s` . `AddressLine2` , `s` . `ContactNumber` , `s` . `CountryId` , `s` . `CreatedBy` , `s` . `CreatedDate` , `s` . `Deleted` , `s` . `DeletedBy` , `s` . `DeletedDate` , `s` . `Email` , `s` . `ModifiedBy` , `s` . `ModifiedDate` , `s` . `PostCode` , `s` . `PreferredOrderingMethod` , `s` . `State` , `s` . `SubUrb` , `s` . `SupplierName` FROM `Suppliers` AS `s` 