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 vote113 views1 answer
Sql show founctions
SQL
0 vote109 views2 answers
Sql use not in
SQL
2 votes109 views2 answers
Sqlite_busy: database is locked
SQL
0 vote102 views1 answer
Modificar tipo de dato sql server
SQL
0 vote106 views1 answer
Mysql a from on this page has
SQL
5 votes99 views3 answers
Sql max value in column
SQL
1 vote107 views1 answer
How to select random rows from a table
SQL
6 votes112 views1 answer
Oracle rank
SQL
2 votes114 views1 answer
Oracle list grants on procedure
SQL
0 vote109 views1 answer
Add super privilege mysql
SQL