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

4 votes208 views2 answers
Sql offset
SQL
0 vote219 views1 answer
Mysql a from on this page has
SQL
0 vote181 views1 answer
Mysql find non alphanumeric characters
SQL
4 votes243 views1 answer
Ms sql truncate table vs delete
SQL
1 vote214 views1 answer
Mysql check string don't have number
SQL
0 vote205 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote200 views2 answers
Sql select only first occurrence
SQL
0 vote209 views1 answer
Oracle list datafiles
SQL
2 votes199 views1 answer
Oracle sql drop table purge
SQL
0 vote206 views1 answer
Postgresql where clause not working
SQL