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 vote332 views1 answer
Mysql uuid
SQL
0 vote309 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
1 vote292 views2 answers
How to drop a unique constraint in sql
SQL
10 votes309 views6 answers
Between sql
SQL
5 votes307 views2 answers
Copy data from one database to another
SQL
0 vote326 views1 answer
Apache Derby: Create SQL Dump with data
SQL
2 votes302 views1 answer
Mysql select random id from table
SQL
1 vote330 views1 answer
Wherein mysql
SQL
0 vote294 views1 answer
Sql min
SQL
8 votes409 views3 answers
Find table for column name in sql
SQL