OMC Customers and their Emails SQL Query

sql

SELECT n.invfname As 'First Name',n.invlname As 'Last Name',n.invcompname As 'Company',n.invtel As 'Tellephone Number',n.invadd1 As 'Address Line 1',n.invadd2 As 'Address Line 2',n.invtown As 'Town',n.invcounty As 'County',n.invpostcode As 'Postcode', e.custID AS 'ID', e.emailAddr AS 'Email Address', e.password AS 'Password'
   FROM custaddressbook AS n
    LEFT JOIN customers AS e
       ON e.custID = n.custid
    WHERE emailAddr IS NOT NULL
    ORDER BY 'First Name'