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

3 votes197 views3 answers
Mysql declare variable
SQL
0 vote314 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote199 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote191 views1 answer
Mysql docker image for macbook m1
SQL
0 vote202 views1 answer
Excel export from sql using python
SQL
0 vote216 views1 answer
Check if mysql db is used
SQL
0 vote193 views1 answer
Sql case sttement with set
SQL
11 votes199 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote142 views1 answer
Oracle sql developer script output limit
SQL
0 vote208 views1 answer
Savepoint mysql script
SQL