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 vote208 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote210 views3 answers
Epoch to datetime
SQL
1 vote216 views1 answer
Media sql
SQL
2 votes214 views1 answer
Query to find table size in oracle 12c
SQL
1 vote220 views1 answer
Sqlite update from another table
SQL
0 vote224 views1 answer
Nosql vs sql
SQL
1 vote229 views1 answer
Update mysql centos
SQL
22 votes280 views4 answers
Mysql format date
SQL
0 vote213 views1 answer
Phpmyadmin tabellentyp ändern
SQL
3 votes207 views1 answer
V$session not found in oracle
SQL