SQLite 3.27

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

SELECT sqlite_version();


sqlite_version()


3.27.2


CREATE TABLE BB (
    SID INTEGER PRIMARY KEY,
    FName TEXT,
    LName TEXT
);
CREATE TABLE QR (
    QID INTEGER PRIMARY KEY AUTOINCREMENT,
    FName TEXT,
    LName TEXT,
    DateTime_IN TEXT,
    Sid4 INTEGER,
    Mode TEXT,
    FOREIGN KEY (FName, LName) REFERENCES BB (FName, LName)
);
INSERT INTO BB (SID, FName, LName) VALUES
(12345678, "R", "B"),
(23456789, "X", "C"),
(34567890, "M", "S"),
(45678901, "Z", "H"),
(56789012, "T", "A"),
(67890123, "N", "F"),
(78901234, "H", "M"),
(89012345, "A", "S"),
(90123456, "F", "F"),
(12345677, "M", "M");
INSERT INTO QR
(FName, LName, DateTime_IN, Sid4, Mode)
VALUES
("R", "B", "2021-08-10 14:00:02", 12345678, "ZOOM"),
("X", "C", "2021-08-10 14:00:02", 23456789, "ZOOM"),
("M", "S", "2021-08-10 14:00:03", 34567890, "ZOOM"),
("Z", "H", "2021-08-10 15:01:01", 45678901, "ZOOM"),
("T", "A", "2021-08-10 14:01:01", 56789012, "ZOOM"),
("N", "F", "2021-08-10 14:02:02", 67890123, "ZOOM"),
("H", "M", "2021-08-10 14:03:03", 78901234, "ZOOM"),
("A", "S", "2021-08-11 14:04:04", 89012345, "ZOOM");
SELECT * FROM QR


QID
FName
LName
DateTime_IN
Sid4
Mode


1
R
B
2021-08-10 14:00:02
12345678
ZOOM

2
X
C
2021-08-10 14:00:02
23456789
ZOOM

3
M
S
2021-08-10 14:00:03
34567890
ZOOM

4
Z
H
2021-08-10 15:01:01
45678901
ZOOM

5
T
A
2021-08-10 14:01:01
56789012
ZOOM

6
N
F
2021-08-10 14:02:02
67890123
ZOOM

7
H
M
2021-08-10 14:03:03
78901234
ZOOM

8
A
S
2021-08-11 14:04:04
89012345
ZOOM

QID	FName	LName	DateTime_IN	Sid4	Mode
1	R	B	2021-08-10 14:00:02	12345678	ZOOM
2	X	C	2021-08-10 14:00:02	23456789	ZOOM
3	M	S	2021-08-10 14:00:03	34567890	ZOOM
4	Z	H	2021-08-10 15:01:01	45678901	ZOOM
5	T	A	2021-08-10 14:01:01	56789012	ZOOM
6	N	F	2021-08-10 14:02:02	67890123	ZOOM
7	H	M	2021-08-10 14:03:03	78901234	ZOOM
8	A	S	2021-08-11 14:04:04	89012345	ZOOM