get the table containing a record

[ayushchd]

hey...

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..?

[mooger35]

Instead of having 2 tables, why not have 1 table with an extra column for "action"?