i have two tables : one for bought shares and one for sold shares.

I want to get the maximum id from both the tables where company = particular company name

and then i want to show :

Latest Trade :
id>>>>>Action>>>>
how can i know that a particular record is of table sold shares or bought shares..?