CREATE CURSOR HasMemo1 (iFK I, mNotes M) INSERT INTO HasMemo VALUES (1, "This is the first note") INSERT INTO HasMemo VALUES (2, "This is the second note") CREATE CURSOR HasMemo2 (iFK I, mNotes M) INSERT INTO HasMemo VALUES (1, "This is a different note") INSERT INTO HasMemo VALUES (2, "So is this") SELECT * FROM HasMemo1 ; UNION ; SELECT * FROM HasMemo2 ; INTO CURSOR ResultYou get only two records in the result, not four, because the memos aren't compared.
OPEN DATABASE HOME(2)+"TasTrade\Data\TasTrade" SELECT customer_id, MAX(order_date), freight ; FROM orders ; GROUP BY 1 ; INTO CURSOR resultThe values for Freight don't match up with the most recent order.