MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE documents (
  id INT,
  name VARCHAR(255)
);
CREATE TABLE downloads (
  id INT,
  document_id INT,
  username VARCHAR(255)
);


INSERT INTO documents VALUES
(1, 'Documents1'),
(2, 'Documents2'),
(3, 'Documents3'),
(4, 'Documents4'),
(5, 'Documents5');

INSERT INTO downloads VALUES
(1, 1, 'sandeep'),
(2, 1, 'simi'),
(3, 2, 'sandeep'),
(4, 2, 'reya'),
(5, 3, 'simi');

SELECT * FROM documents;
SELECT * FROM downloads;

Records: 5  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0




id
name


1
Documents1

2
Documents2

3
Documents3

4
Documents4

5
Documents5




id
document_id
username


1
1
sandeep

2
1
simi

3
2
sandeep

4
2
reya

5
3
simi


SELECT *
FROM documents
LEFT JOIN downloads ON documents.id = downloads.document_id
WHERE username = 'sandeep';


id
name
id
document_id
username


1
Documents1
1
1
sandeep

2
Documents2
3
2
sandeep


SELECT *
FROM documents
LEFT JOIN downloads ON documents.id = downloads.document_id AND username = 'sandeep';


id
name
id
document_id
username


1
Documents1
1
1
sandeep

2
Documents2
3
2
sandeep

3
Documents3
null
null
null

4
Documents4
null
null
null

5
Documents5
null
null
null

id	name	id	document_id	username
1	Documents1	1	1	sandeep
2	Documents2	3	2	sandeep
3	Documents3	null	null	null
4	Documents4	null	null	null
5	Documents5	null	null	null