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 vote186 views1 answer
Sql case sttement with set
SQL
0 vote240 views3 answers
Mysql keyword search
SQL
0 vote169 views1 answer
How to get initials in sql
SQL
1 vote210 views3 answers
Psql fatal database does not exist
SQL
2 votes177 views1 answer
Sql update alias
SQL
0 vote178 views1 answer
Sql date d'aujourd'hui
SQL
1 vote181 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote171 views1 answer
Remove binlog mysql
SQL
2 votes184 views1 answer
Oracle generated column
SQL
11 votes189 views2 answers
Having in sql
SQL