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 vote265 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote272 views1 answer
Casterar postgres
SQL
0 vote288 views1 answer
Xamarin sql lite create table if not exist
SQL
31 votes280 views3 answers
SQL Server change column data type
SQL
0 vote293 views1 answer
Group by 15 minute interval sql server
SQL
2 votes275 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote290 views1 answer
Replace all numbers in mysql
SQL
0 vote318 views1 answer
Sql find gaps in date ranges
SQL
3 votes297 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
1 vote268 views2 answers
Find a column in all tables mysql
SQL