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 vote153 views1 answer
Utf8_encode mysql
SQL
0 vote140 views1 answer
<script>alert
SQL
0 vote151 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote147 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
5 votes161 views4 answers
Start postgres server
SQL
-1 vote150 views1 answer
How to create foreign key in sql server management studio
SQL
2 votes156 views1 answer
Oracle list grants on procedure
SQL
4 votes141 views4 answers
What is primary key
SQL
1 vote178 views1 answer
Epoch time converter in snowflake
SQL
0 vote132 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL