MySQL 5.7

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

select version();


version()


5.7.39


CREATE TABLE IF NOT EXISTS `truck` (
  `truck_id` varchar(12) NOT NULL,    # license plate
  `is_online` tinyint(1) DEFAULT '0',
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`truck_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO truck(truck_id) VALUES 
  ("ABC123"),
  ("DEF123"),
  ("ADF134");

Records: 3  Duplicates: 0  Warnings: 0


SELECT * FROM truck


truck_id
is_online
deleted_at


ABC123
0
null

ADF134
0
null

DEF123
0
null


CREATE TABLE IF NOT EXISTS `consignment` (
  `consignment_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `shipment` varchar(255) NOT NULL,
  `transporter` varchar(255) NOT NULL,
  `truck_id` varchar(12) NOT NULL,
  PRIMARY KEY (`consignment_id`),
  KEY `consignment_truck_id_index` (`truck_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;
INSERT INTO consignment(shipment, transporter, truck_id) VALUES 
  ("shipment1", "transporter1", "ABC123"), 
  ("shipment2", "transporter2", "ABC123"), 
  ("shipment3", "transporter3", "DEF123"),
  ("shipment4", "transporter4", "DEF123"),
  ("shipment5", "transporter5", "DEF123"),
  ("shipment6", "transporter6", "DEF123");

Records: 6  Duplicates: 0  Warnings: 0


SELECT * FROM consignment


consignment_id
shipment
transporter
truck_id


30
shipment1
transporter1
ABC123

31
shipment2
transporter2
ABC123

32
shipment3
transporter3
DEF123

33
shipment4
transporter4
DEF123

34
shipment5
transporter5
DEF123

35
shipment6
transporter6
DEF123


SELECT c.*, t.*
FROM consignment as c
JOIN truck as t
ON c.`truck_id` = t.truck_id
GROUP BY c.truck_id;

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fiddle.c.consignment_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

consignment_id	shipment	transporter	truck_id
30	shipment1	transporter1	ABC123
31	shipment2	transporter2	ABC123
32	shipment3	transporter3	DEF123
33	shipment4	transporter4	DEF123
34	shipment5	transporter5	DEF123
35	shipment6	transporter6	DEF123