SELECT T1.cust_name FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id  =  T2.cust_id WHERE loan_type  =  'Mortgages' INTERSECT SELECT T1.cust_name FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id  =  T2.cust_id WHERE loan_type  =  'Auto'
Find the name of customers who have loans of both Mortgages and Auto.
SELECT T1.cust_name FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id = T2.cust_id WHERE loan_type = 'Mortgages ' INTERSECT SELECT T1.cust_name FROM customer AS T1 JOIN loan AS T2 ON T1.cust_id = T2.cust_id WHERE loan_type = 'Auto '
select t1 . cust_name from customer as t1 join loan as t2 on t1 . cust_id = t2 . cust_id where loan_type = value intersect select t1 . cust_name from customer as t1 join loan as t2 on t1 . cust_id = t2 . cust_id where loan_type = value
Find the name of customers who have loans of both Mortgages and Auto .