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 vote309 views1 answer
How to install Firebird
SQL
0 vote306 views1 answer
Postgres delete where id in
SQL
2 votes336 views1 answer
Columns Present in a table
SQL
36 votes349 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote323 views1 answer
Sql string length postgresql
SQL
0 vote328 views1 answer
Sql server order by nulls last
SQL
3 votes374 views4 answers
Truncate syntax in sql
SQL
0 vote367 views1 answer
Local pg_sql to heroku pg_sql
SQL
25 votes372 views4 answers
Sqlserver add column
SQL
0 vote355 views5 answers
Sql table intermédiaire
SQL