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 vote160 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
1 vote153 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote153 views2 answers
Auto increment column in mysql query results
SQL
0 vote165 views1 answer
Show tables in cassandra cql
SQL
0 vote136 views1 answer
Get who is hired in month in sql
SQL
1 vote156 views5 answers
Postgresql difference between two dates in days
SQL
0 vote154 views1 answer
Sql reverse order of results
SQL
1 vote165 views1 answer
Sql current timestamp
SQL
2 votes157 views1 answer
Oracle convert run_duration to number
SQL
0 vote161 views2 answers
Advantages of stored procedures sql
SQL