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 vote130 views1 answer
Mysql backup skip table
SQL
14 votes128 views6 answers
Auto_increment mysql
SQL
0 vote131 views1 answer
Sql server isnull function nor working count
SQL
0 vote131 views1 answer
Provide hardcoded value in the mysql query
SQL
2 votes196 views1 answer
Postgresql group by month and year
SQL
-2 votes131 views1 answer
Mysql see users and passwords
SQL
0 vote132 views1 answer
How to run mysql in git bash
SQL
0 vote168 views1 answer
Sql server is not
SQL
0 vote141 views1 answer
How to retrive the today date sql
SQL
0 vote122 views1 answer
Top frequency in sql server
SQL