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

7 votes241 views1 answer
Sql server convert string to date
SQL
3 votes262 views3 answers
Update con select postgresql
SQL
0 vote262 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
3 votes227 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote228 views1 answer
Mysql shell set time_zone
SQL
2 votes250 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote239 views1 answer
Login failed for user sql server
SQL
2 votes237 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote246 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote230 views1 answer
Check mysql password with docker container magento 2
SQL