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

1 vote233 views1 answer
How to show index type in postgresql
SQL
0 vote221 views1 answer
Minecraft duping allowed servers
SQL
0 vote219 views1 answer
Postgresql log
SQL
1 vote216 views2 answers
Populate sql table with random data
SQL
1 vote226 views1 answer
Sql to mongodb query converter
SQL
1 vote228 views1 answer
Mysql tables max count
SQL
0 vote220 views1 answer
Sub blocks in sql
SQL
0 vote218 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote258 views1 answer
Sql quary stuf
SQL
0 vote216 views1 answer
Difference between cross apply and inner join
SQL