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

13 votes279 views4 answers
Sql joining 3 tables
SQL
0 vote169 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
3 votes181 views2 answers
Oracle sql first day of month
SQL
2 votes135 views1 answer
Set column to not null mysql
SQL
0 vote97 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote133 views1 answer
Drop all tables db2
SQL
11 votes139 views2 answers
MySQL DISTINCT
SQL
1 vote141 views2 answers
How to search date in sql query
SQL
10 votes88 views1 answer
Oracle view dependencies
SQL
0 vote149 views2 answers
Nodejs mysql convert to plain object
SQL