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 vote180 views1 answer
Simple project for database
SQL
0 vote176 views1 answer
Mysql concat and use as where column
SQL
0 vote187 views1 answer
Mysql set boolean default value
SQL
0 vote173 views1 answer
Drop constraint in ms sql
SQL
0 vote173 views1 answer
Postgresql alter column nullable
SQL
3 votes172 views2 answers
Sql server current date without time
SQL
1 vote258 views3 answers
Date_add mysql
SQL
-1 vote181 views1 answer
Export mysql table to file
SQL
0 vote180 views1 answer
Sql server set complex constraints
SQL
1 vote174 views1 answer
Sql auto timestamp
SQL