Okay I have this query statement
SELECT "Acquisition" AS MovementType, LotNumber, Quantity, UserID
FROM StockAcquisitions
UNION ALL
SELECT "Withdrawal" , LotNumber, Quantity*-1, UserID
FROM StockWithdrawals
UNION ALL SELECT "Stocktake", LotNumber, Quantity, UserID
FROM StockTakes;
Now what I want is that this query also displays me the UserName. But the UserName is in the table Users and I don't know how to join this field already having this union all statement. Help as always appreciated.