CREATE TABLE Customers
(
  Customer_ID varchar(5),
  Customer_Name varchar(20),
  Standing boolean,
  Balance int
);
 
CREATE TABLE Customer_Complaints
(
  Note_ID int,
  Customer_ID varchar(5),
  Note_Date date,
  Note varchar(50)
);
 
INSERT INTO Customers (Customer_ID, Customer_Name, Standing, Balance) Values ('Ham', 'Ham Bone', 1, 400);
INSERT INTO Customers (Customer_ID, Customer_Name, Standing, Balance) Values ('Steak','Steak Bone', 0, -500);
 
INSERT INTO Customer_Complaints (Note_ID, Customer_ID, Note_Date, Note) Values (1,'Ham',DATE('1983-08-08'),'They were really mad');
INSERT INTO Customer_Complaints (Note_ID, Customer_ID, Note_Date, Note) Values (2,'Ham',DATE('1989-08-08'),'Not as mad this time');
 
SELECT t.Customer_ID, t.Balance, s.Note
FROM Customers AS t
LEFT JOIN Customer_Complaints AS s ON t.Customer_ID = s.Customer_ID
WHERE  s.Note_ID =   (SELECT MAX(Note_Date)
					  FROM Customer_Complaints AS m
					  WHERE m.Customer_ID = t.Customer_ID)

Q1JFQVRFIFRBQkxFIEN1c3RvbWVycwooCiAgQ3VzdG9tZXJfSUQgdmFyY2hhcig1KSwKICBDdXN0b21lcl9OYW1lIHZhcmNoYXIoMjApLAogIFN0YW5kaW5nIGJvb2xlYW4sCiAgQmFsYW5jZSBpbnQKKTsKCkNSRUFURSBUQUJMRSBDdXN0b21lcl9Db21wbGFpbnRzCigKICBOb3RlX0lEIGludCwKICBDdXN0b21lcl9JRCB2YXJjaGFyKDUpLAogIE5vdGVfRGF0ZSBkYXRlLAogIE5vdGUgdmFyY2hhcig1MCkKKTsKCklOU0VSVCBJTlRPIEN1c3RvbWVycyAoQ3VzdG9tZXJfSUQsIEN1c3RvbWVyX05hbWUsIFN0YW5kaW5nLCBCYWxhbmNlKSBWYWx1ZXMgKCdIYW0nLCAnSGFtIEJvbmUnLCAxLCA0MDApOwpJTlNFUlQgSU5UTyBDdXN0b21lcnMgKEN1c3RvbWVyX0lELCBDdXN0b21lcl9OYW1lLCBTdGFuZGluZywgQmFsYW5jZSkgVmFsdWVzICgnU3RlYWsnLCdTdGVhayBCb25lJywgMCwgLTUwMCk7CgpJTlNFUlQgSU5UTyBDdXN0b21lcl9Db21wbGFpbnRzIChOb3RlX0lELCBDdXN0b21lcl9JRCwgTm90ZV9EYXRlLCBOb3RlKSBWYWx1ZXMgKDEsJ0hhbScsREFURSgnMTk4My0wOC0wOCcpLCdUaGV5IHdlcmUgcmVhbGx5IG1hZCcpOwpJTlNFUlQgSU5UTyBDdXN0b21lcl9Db21wbGFpbnRzIChOb3RlX0lELCBDdXN0b21lcl9JRCwgTm90ZV9EYXRlLCBOb3RlKSBWYWx1ZXMgKDIsJ0hhbScsREFURSgnMTk4OS0wOC0wOCcpLCdOb3QgYXMgbWFkIHRoaXMgdGltZScpOwoKU0VMRUNUIHQuQ3VzdG9tZXJfSUQsIHQuQmFsYW5jZSwgcy5Ob3RlCkZST00gQ3VzdG9tZXJzIEFTIHQKTEVGVCBKT0lOIEN1c3RvbWVyX0NvbXBsYWludHMgQVMgcyBPTiB0LkN1c3RvbWVyX0lEID0gcy5DdXN0b21lcl9JRApXSEVSRSAgcy5Ob3RlX0lEID0gICAoU0VMRUNUIE1BWChOb3RlX0RhdGUpCgkJCQkJICBGUk9NIEN1c3RvbWVyX0NvbXBsYWludHMgQVMgbQoJCQkJCSAgV0hFUkUgbS5DdXN0b21lcl9JRCA9IHQuQ3VzdG9tZXJfSUQp