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 vote272 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote259 views1 answer
Dasebase_url-postgres for windows
SQL
16 votes287 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
3 votes263 views1 answer
Oracle apex message quit website
SQL
1 vote272 views1 answer
Oracle sql create view
SQL
6 votes295 views2 answers
Postgresql database url
SQL
1 vote271 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote271 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote303 views1 answer
Dynamic where clause in sql server stored procedure
SQL
2 votes270 views4 answers
Mysql select into new table
SQL