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 vote128 views1 answer
Sqlite unique multiple columns
SQL
0 vote65 views1 answer
Select mysql limit to 2 decimal places
SQL
9 votes116 views1 answer
Oracle get table schema
SQL
1 vote99 views1 answer
Mysql check if string contains comma separated
SQL
0 vote132 views1 answer
SQL joins in python
SQL
0 vote101 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote112 views1 answer
Sql mod even odd
SQL
5 votes114 views2 answers
Oracle list columns
SQL
0 vote118 views1 answer
Sql server list table sizes
SQL
3 votes103 views2 answers
Current year sql
SQL