I'm in front of a little issue after concatenating two tables.
I've two table with same kind of data:
1st table: Customer N° / Begin Date / Final Date
2nd Table: Customer N° / Begin Date / Final Date
The difference between the two table is that the first table concerns a paid service and the second, a free service.
I would like to create a table with the Customer N° / Begin Date/ Final Date / Service fee.
So as you can imagnie, my issue is to detect if the begin or final date belongs to the first or second table, in order to say if the Service fee is free or paid.
Moreover, you can have a Customer that have the two services, one paid, and one free, my objective is to see the ratio of those.
Hope i'm clear and smbdy can help me, i guess their is a function that enable that, but unable to find it.
