MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE memb 
(
  last_m VARCHAR (30),
  CONSTRAINT memb_pk PRIMARY KEY (last_m) 
);
INSERT INTO memb VALUES ('ANDRES, JOSE');
INSERT INTO memb VALUES ('LORISA, MARIA');
INSERT INTO memb VALUES ('SENINA, JUSTINA'); 
INSERT INTO memb VALUES ('TAN, LOLITA');
CREATE TABLE tblprint
(
  last_m VARCHAR (30),
  printdate DATETIME NOT NULL,
  CONSTRAINT tp_pk PRIMARY KEY (last_m, printdate),
  CONSTRAINT tp_memb_fk FOREIGN KEY (last_m) REFERENCES memb (last_m)
);
INSERT INTO tblprint VALUES ('ANDRES, JOSE', '2019-07-29 13:39:44');
INSERT INTO tblprint VALUES ('ANDRES, JOSE', '2001-09-01 23:33:41');
INSERT INTO tblprint VALUES ('ANDRES, JOSE', '2002-07-29 13:33:42');
INSERT INTO tblprint VALUES ('ANDRES, JOSE', '2003-07-29 13:33:43');
INSERT INTO tblprint VALUES ('ANDRES, JOSE', '2024-07-29 13:33:24');
INSERT INTO tblprint VALUES ('ANDRES, JOSE', '2020-07-29 20:20:20');

INSERT INTO tblprint VALUES ('LORISA, MARIA', '2014-07-29 13:34:44');
INSERT INTO tblprint VALUES ('LORISA, MARIA', '2007-07-29 13:31:44');
INSERT INTO tblprint VALUES ('LORISA, MARIA', '2008-07-29 13:32:44');
INSERT INTO tblprint VALUES ('LORISA, MARIA', '2009-07-29 13:33:44');
INSERT INTO tblprint VALUES ('LORISA, MARIA', '2018-07-29 13:35:44');
INSERT INTO tblprint VALUES ('LORISA, MARIA', '2021-07-29 13:37:44');
INSERT INTO tblprint VALUES ('LORISA, MARIA', '2020-07-29 13:36:44');

-- works in 5.6 and 8

SELECT 
  tp.last_m,
  MAX(tp.printdate) AS "p_date"
FROM
  tblprint tp
GROUP BY tp.last_m
ORDER BY last_m, p_date;


last_m
p_date


ANDRES, JOSE
2024-07-29 13:33:24

LORISA, MARIA
2021-07-29 13:37:44


-- works in 5.6 and 8

SELECT 
  m.last_m,
  -- tp.last_m -- put this in to experiment
  MAX(tp.printdate) AS "p_date"
  -- COALESCE(MAX(tp.printdate), '"NULL"') AS "for_display" -- optional, just for show!
FROM
  tblprint tp
RIGHT JOIN memb m
  ON tp.last_m = m.last_m
GROUP BY last_m
ORDER BY last_m, p_date;

  
  


last_m
p_date


ANDRES, JOSE
2024-07-29 13:33:24

LORISA, MARIA
2021-07-29 13:37:44

SENINA, JUSTINA
null

TAN, LOLITA
null


-- This is a hack.
-- works in 5.6 and 8

SELECT 
  tp.last_m,
  MAX(tp.printdate) AS "p_date"
FROM
  tblprint tp
GROUP BY tp.last_m
UNION
SELECT 
  m.last_m, 
  NULL
FROM
  memb m
WHERE m.last_m NOT IN (SELECT last_m FROM tblprint)
ORDER BY last_m, p_date


last_m
p_date


ANDRES, JOSE
2024-07-29 13:33:24

LORISA, MARIA
2021-07-29 13:37:44

SENINA, JUSTINA
null

TAN, LOLITA
null


-- proposed by https://dba.stackexchange.com/users/175682/hiteshrathi

-- the query RUNS (but returns incorrect results - note the dependence
-- on the order of the tblprint INSERTs) in 5.6 but will NOT RUN in 8

-- this is because of version 8's use of sql_mode = only_full_group_by 
-- by default. Using 5.6's default behaviour will cause errors eventually

-- ANDRES, JOSE's printdate is wrong! Should be 2024 and LORISA, MARIA
-- should be 2021

SELECT distinct memb.last_m, printdate AS printdate 
FROM memb
LEFT JOIN  tblprint ON memb.last_m = tblprint.last_m  
group by    
        memb.last_m 
ORDER BY last_m, printdate DESC;


last_m
printdate


ANDRES, JOSE
2001-09-01 23:33:41

LORISA, MARIA
2007-07-29 13:31:44

SENINA, JUSTINA
null

TAN, LOLITA
null


-- RUNs in 5.6 (but does not WORK) but NOT RUN in 8

SELECT 
  m.last_m,
  tp.printdate AS "p_date"
FROM
  tblprint tp
RIGHT JOIN
memb m ON
tp.last_m = m.last_m
GROUP BY m.last_m
ORDER BY m.last_m, tp.printdate;


last_m
p_date


ANDRES, JOSE
2001-09-01 23:33:41

LORISA, MARIA
2007-07-29 13:31:44

SENINA, JUSTINA
null

TAN, LOLITA
null


-- works in 5.6 but not in 8

SELECT 
  m.last_m AS "Name",
  MAX(tp.printdate)
FROM memb m
LEFT JOIN  tblprint tp 
  ON m.last_m = tp.last_m
GROUP BY
        m.last_m
ORDER BY m.last_m, tp.printdate DESC;


Name
MAX(tp.printdate)


ANDRES, JOSE
2024-07-29 13:33:24

LORISA, MARIA
2021-07-29 13:37:44

SENINA, JUSTINA
null

TAN, LOLITA
null
last_m	p_date
ANDRES, JOSE	2024-07-29 13:33:24
LORISA, MARIA	2021-07-29 13:37:44
last_m	printdate
ANDRES, JOSE	2001-09-01 23:33:41
LORISA, MARIA	2007-07-29 13:31:44
SENINA, JUSTINA	null
TAN, LOLITA	null