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 vote139 views2 answers
Sql server select where date
SQL
17 votes165 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote146 views4 answers
Change schema in sql server
SQL
8 votes145 views1 answer
How to check mysql version in xampp
SQL
1 vote157 views1 answer
Opensuse restart MySQL
SQL
1 vote167 views1 answer
Mysql current running queries
SQL
5 votes143 views2 answers
Sql server port number
SQL
0 vote152 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote239 views1 answer
How to select department from table
SQL
0 vote145 views2 answers
Sql query for getting details by id
SQL