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 activitis also
Page 1 / 1
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.