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 vote231 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote238 views1 answer
Get from database the most recent data limit by 5
SQL
1 vote186 views1 answer
Can we drop a primary key
SQL
0 vote189 views1 answer
Sql create text column limited values
SQL
7 votes188 views1 answer
Append column sql
SQL
0 vote209 views1 answer
Sqlalchemy get schema from database
SQL
1 vote285 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote180 views1 answer
Error code 1241 mysql
SQL
0 vote233 views1 answer
How to open mysql in docker
SQL
0 vote223 views1 answer
Select all same column value in sql
SQL