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 vote151 views1 answer
Assign value to var in SQL
SQL
12 votes155 views1 answer
Docker mysql random root password
SQL
3 votes168 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote163 views1 answer
Alter rename command in mysql
SQL
11 votes162 views1 answer
Sql insert multiple rows from select
SQL
0 vote169 views1 answer
Select odd records sql
SQL
0 vote158 views1 answer
Sql new line output
SQL
2 votes200 views1 answer
Show max_allowed_packet mysql
SQL
4 votes184 views1 answer
Ms sql truncate table vs delete
SQL
0 vote177 views1 answer
Synapse sql table set pk
SQL