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 vote305 views3 answers
Get all tables postgres
SQL
5 votes323 views1 answer
Oracle nls session
SQL
0 vote305 views1 answer
Create table with float datatype in sql server
SQL
1 vote277 views3 answers
Remove unique key from a table
SQL
0 vote309 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote331 views1 answer
Table structure in sql
SQL
10 votes307 views6 answers
Sql between
SQL
0 vote292 views1 answer
TSQL function split string
SQL
0 vote343 views1 answer
Traccar mysql
SQL
0 vote252 views2 answers
Delete the last item in a table sql
SQL