SELECT FirstName, ID, (CASE WHEN EXISTS (SELECT id FROM application WHERE Customer.id = Application.ID) THEN 'AA' END) FROM Customer