SELECT customer.id, customer.firstName, customer.lastName, customer.loginName, customer.isActive FROM customer ORDER BY customer.lastName, customer.firstName SELECT customer.id, customer.firstName, customer.lastName, customer.loginName, customer.isActive FROM customer WHERE customer.isActive = 1 ORDER BY customer.lastName, customer.firstName SELECT customer.id, customer.firstName, customer.lastName, customer.loginName, customer.isActive, address.streetAddress1, address.streetAddress2, address.city, address.state, address.zip FROM customer INNER JOIN address ON customer.id = address.customerID WHERE 1=1 AND address.city = AND address.state = AND address.zip = ORDER BY customer.lastName, customer.firstName SELECT customer.id, customer.firstName, customer.lastName, customer.loginName, customer.isActive, address.streetAddress1, address.streetAddress2, address.city, address.state, address.zip FROM customer LEFT OUTER JOIN address ON customer.id = address.customerID WHERE 1=1 AND customer.firstName LIKE '#arguments.firstName#%' AND customer.firstName LIKE '#arguments.lastName#%' AND customer.firstName = AND customer.isActive = AND address.city = AND address.state = AND address.zip = ORDER BY #arguments.orderByColumn# customer.lastName, customer.firstName