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 vote134 views1 answer
Select first rows postgresql
SQL
13 votes113 views3 answers
Sql online code
SQL
0 vote135 views1 answer
Traccar mysql
SQL
11 votes427 views4 answers
Reset identity column values in sql server
SQL
32 votes118 views6 answers
Insert into values select
SQL
1 vote126 views1 answer
Sql where max date
SQL
3 votes116 views2 answers
Order by postgresql
SQL
7 votes123 views4 answers
Database dump mysql command
SQL
1 vote134 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote133 views1 answer
Mysql last friday of current month
SQL