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 vote331 views1 answer
How to rename a database in tsql
SQL
1 vote250 views1 answer
Delete mysql from mac
SQL
1 vote260 views1 answer
Get rows affected mysql python
SQL
0 vote274 views1 answer
To Create directory
SQL
7 votes260 views1 answer
Minecraft forge server host
SQL
1 vote293 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote273 views4 answers
User defined function sql
SQL
0 vote216 views1 answer
Connection error in mysql workbench
SQL
0 vote284 views1 answer
Create boolean column in MySQL with false as default value?
SQL
1 vote261 views1 answer
Calculate age in sql postgresql
SQL