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

11 votes350 views4 answers
Round in sql
SQL
1 vote177 views2 answers
Mysql remove first and last character from string
SQL
0 vote213 views1 answer
Sql query for login with email or username
SQL
1 vote167 views1 answer
Sql drop with dependencies
SQL
1 vote166 views1 answer
Oracle select first result
SQL
0 vote179 views3 answers
Query string not ending with with vowels
SQL
1 vote144 views1 answer
Unique vs distinct sql
SQL
1 vote186 views1 answer
Mysql limit results to 10
SQL
0 vote226 views1 answer
Sqlite trim
SQL
2 votes172 views1 answer
Oracle generated column
SQL