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 vote101 views1 answer
Optimize sql query
SQL
1 vote105 views1 answer
Mariadb alter user host
SQL
0 vote110 views1 answer
Android sqlite add column if not exists
SQL
0 vote116 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
3 votes106 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote108 views1 answer
Amount of entries in a table psql
SQL
53 votes272 views6 answers
How to install mysql ubuntu
SQL
0 vote130 views2 answers
Insert data into multiple tables mysql
SQL
8 votes100 views2 answers
Between operator
SQL
3 votes98 views1 answer
Search for column name in psql
SQL