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

2 votes165 views2 answers
Mysql user access to database
SQL
4 votes176 views1 answer
Conda install sqlalchemy
SQL
0 vote244 views1 answer
Mysql equivalent decode oracle
SQL
1 vote180 views1 answer
Sql server update column based on another table
SQL
1 vote178 views2 answers
Mysql between
SQL
0 vote157 views1 answer
Find largest table in mysql database
SQL
0 vote192 views1 answer
Min varias colunas spark sql
SQL
0 vote177 views1 answer
Mysql query with sql to get the next row
SQL
0 vote165 views2 answers
Get all index postgres
SQL
1 vote175 views1 answer
How to check the mysql version mac
SQL