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 vote316 views1 answer
Show table columns
SQL
0 vote339 views1 answer
Drush run sql select
SQL
0 vote323 views1 answer
Mysql count by month
SQL
0 vote388 views1 answer
Mysql get nth highest
SQL
3 votes311 views1 answer
Oracle detect invalid password
SQL
0 vote336 views1 answer
Vowels in sql
SQL
1 vote335 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote279 views1 answer
How to check oracle index table
SQL
0 vote367 views1 answer
Check if mysql db is used
SQL
1 vote330 views1 answer
Oracle create as select
SQL