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 vote352 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote377 views1 answer
Excel export from sql using python
SQL
0 vote366 views1 answer
Sql describe
SQL
0 vote315 views1 answer
Mysql find foreign key references
SQL
1 vote360 views1 answer
Postgres set column equal to another
SQL
3 votes364 views2 answers
Oracle drop column
SQL
5 votes348 views2 answers
Oracle show procedures
SQL
0 vote419 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote356 views1 answer
Sql server union if table exist
SQL
0 vote357 views1 answer
Create date sql
SQL