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 vote290 views1 answer
Mysql installer no packages found
SQL
1 vote342 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote327 views1 answer
Mysql value ends with
SQL
0 vote302 views1 answer
Sql revert migration
SQL
3 votes273 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
25 votes381 views5 answers
Mysql replace text
SQL
3 votes286 views1 answer
Sql multiple column index
SQL
4 votes294 views1 answer
Adding data to table in sql python
SQL
0 vote286 views1 answer
Show all mongodb
SQL
0 vote308 views1 answer
Postgresql using reserved word as column name
SQL