I have created an activity table with 5 activities,i also created the change activities by joining both activity table and change table,but when i use select distinct activities from activity table im getting only 5 activities,i want change acti

Any reason you are adding these in different tables ?

You can try creating a eventlog with a case when condition like

Case when activity table. activity is not null the activity table. activity

when change table .activity is not null the change table . activity

end

The better approach is to have all you activities in activity table itself.