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 vote44 views2 answers
How to check username in mysql command line
SQL
0 vote43 views1 answer
10000000000000000000 am to meters
SQL
23 votes46 views6 answers
Delete all rows from table sql
SQL
0 vote50 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote40 views2 answers
Mysql update two tables at once
SQL
0 vote50 views1 answer
Get first monday of month sql
SQL
0 vote3 views1 answer
Mysql workbench search all tables
SQL
1 vote44 views1 answer
What is intersect
SQL
1 vote45 views1 answer
Mysql last year
SQL
0 vote44 views1 answer
Query to get all primary keys and foreign key
SQL