Table structure:

create table A

id1 int,

status int

date created datetime

table B

id2 int

status int

date created datetime

table c

id3 int

status int

date created datetime

table status

id

description

The description field will be like pending, new etc...

i need the output as mentioned above..