CREATE TABLE policies (customer_id VARCHAR, policy_type_code VARCHAR); CREATE TABLE customers (customer_details VARCHAR, customer_id VARCHAR)
SELECT DISTINCT t2.customer_details FROM policies AS t1 JOIN customers AS t2 ON t1.customer_id = t2.customer_id WHERE t1.policy_type_code = "Deputy" OR t1.policy_type_code = "Uniform"
ค้นหาชื่อลูกค้าที่มีนโยบายรองหรือนโยบายเครื่องแบบ
Find the names of customers who either have an deputy policy or uniformed policy.