Customer using hdfc bank sql query

select distinct u.name, u.address from users u
join bookingdetails b on b.user_id = u.user_id
where u.user_id not in 
( select user_id from bookingdetails where name='HDFC')
order by u.name;

Similar codes

0 vote191 views2 answers
Get all index postgres
SQL
0 vote199 views1 answer
Oracle cpu metric
SQL
2 votes188 views1 answer
Pandas to sql index
SQL
-1 vote204 views2 answers
Create temporary table sql
SQL
1 vote181 views1 answer
Nested if in mysql
SQL
0 vote195 views1 answer
Sql sum show 0 result
SQL
0 vote220 views1 answer
Sql sort ages
SQL
0 vote205 views1 answer
Date datatype in livesql
SQL
0 vote198 views1 answer
Sql server roles and users
SQL
20 votes192 views3 answers
SQL query rename table
SQL