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 vote158 views1 answer
Sql server loop over query
SQL
6 votes144 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote129 views1 answer
Copy Table from SQL to CSV
SQL
1 vote129 views2 answers
Grab part of a string sql
SQL
1 vote137 views1 answer
Postgresql transaction discard all
SQL
5 votes149 views1 answer
How to get all table names in sql query
SQL
0 vote137 views1 answer
Power query datetime to date
SQL
4 votes125 views2 answers
Tsql utf to local time
SQL
0 vote145 views1 answer
Allow null in psql
SQL
0 vote137 views1 answer
C# get sql min date
SQL