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 vote204 views2 answers
Sql convert datetime to year month
SQL
1 vote302 views1 answer
Sql server read uncommitted
SQL
6 votes254 views2 answers
WHERE value IS sql
SQL
0 vote227 views1 answer
Add two days to current date in sql when creating tables
SQL
1 vote268 views1 answer
Psql connect
SQL
0 vote210 views1 answer
To_date sql
SQL
0 vote168 views1 answer
Postgres delete where id in
SQL
0 vote218 views1 answer
Kotlin sqlite delete row
SQL
0 vote219 views1 answer
Como hacer una consulta en sql
SQL
11 votes209 views3 answers
Python sqlite3 create table if not exists
SQL