Select Values from a table sorted by most recent DATE for each ID

I have a table with a complete list of all products as shown below:

Table "Products"

There is another table containing transactions of these products. Each item code can be in the table once, multiple times or not at all under same or different dates as shown below:

Table "Transactions"

I would like to get the list of all products from the Products table and then get corresponding latest record by date from transactions if available for each of the item code.

Result would look as below:

Includes all the item codes whether or not it has any transaction. Date is whichever the most recent and same qty from that date.

Result Set

I am using the following query to join the multiple tables but having trouble on the latter statement:

SELECT a.itemcode, a.productname, b.date, b.qty FROM 

(SELECT * FROM products) AS a LEFT JOIN 
(SELECT * FROM transactions......) AS b ON a.itemcode = b.itemcode;

You can do something like the following where you perform left join to make sure all products are included and use MAX function to get the most recent date of transaction for that particular product. Then you can sort as needed (I've sorted by item code because that's what your result set looks like).

SELECT 
    p."Item Code", 
    t.Date, 
    t.Qty
FROM 
    "Products" p
LEFT JOIN "Transactions" t 
    ON p."Item Code" = t."Item Code"
    AND t.Date = (
        SELECT MAX(Date)
        FROM "Transactions"
        WHERE "Item Code" = p."Item Code"
    )
ORDER BY p."Item Code";