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 vote363 views1 answer
Psql lst trigger
SQL
0 vote374 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
-1 vote349 views1 answer
Adding a new table psql
SQL
-1 vote388 views1 answer
Sql select data from one database and insert into a different database
SQL
3 votes446 views2 answers
Wp do sql query from function
SQL
1 vote362 views1 answer
Insert column after column mysql
SQL
0 vote408 views1 answer
Insert query return id mysql
SQL
0 vote354 views1 answer
Como hacer un select entre fechas mysql
SQL
62 votes492 views8 answers
Mysql add column
SQL
4 votes354 views1 answer
Oracle show errors compilation
SQL