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

2 votes142 views1 answer
Mysql virtual column
SQL
0 vote165 views3 answers
Mysql keyword search
SQL
1 vote156 views1 answer
Second last highest id in sql
SQL
24 votes136 views6 answers
Rename a column in sql server
SQL
0 vote155 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote107 views2 answers
Procedure pl/sql
SQL
0 vote135 views1 answer
Sql remove last x char
SQL
0 vote127 views1 answer
Count the table indatabase
SQL
0 vote168 views1 answer
Testing sql queries
SQL
1 vote141 views1 answer
Mariadb get column names from table
SQL