it will give your Expected output
To select All Columns
Select * from transaction t
join City_Master cm on t.Alt_City=cm.id
For selected Columns
Select t.Supplier_Name,t.Product,t.Qty,cm.City from transaction t
join City_Master cm on t.Alt_City=cm.id
for more info about join please visit
this link