How can I remove duplicate results in the following sql?

```
SELECT    * 
FROM      fccestimatedcustomer LEFT JOIN fcccustomerregistration 
ON        fccestimatedcustomer.CustomerRegistrationRefID = 
          fcccustomerregistration.CustomerRegistrationRefID
WHERE     fccestimatedcustomer.Status = 1 
ORDER BY  VehicleNumber ASC;

```