CREATE TABLE Client
(
ClientID INTEGER,
ClientName VARCHAR(30),
DateOfBirth DATE,
Gender CHAR(1)
)

CREATE TABLE Glucose
(
ClientID INTEGER,
GlucoseDate DATE,
GlucoseValue INTEGER
)

CREATE TABLE BP
(
ClientID INTEGER,
BPDate DATE,
SystolicBP INTEGER,
DiastolicBP INTEGER
)

SELECT ClientID,
ClientName,
DateOfBirth,
(SELECT SystolicBP
FROM BP
WHERE BP.ClientID=Client.ClientID
ORDER BY BPDate DESC
RANGE 1 TO 1) AS SystolicBP,
(SELECT DiastolicBP
FROM BP
WHERE BP.ClientID=Client.ClientID
ORDER BY BPDate DESC
RANGE 1 TO 1) AS DiastolicBP,
(SELECT GlucoseValue
FROM Glucose
WHERE Glucose.ClientID=Client.ClientID
ORDER BY GlucoseDate DESC
RANGE 1 TO 1) AS GlucoseValue
FROM Client
ORDER BY ClientID