Javad Kondori

Hi all,

Does anyone have any idea for the following statement?

"Select A, If Duration of B>D and D>C
or Select A if B started before D and C"

or anything to select all capsules of A by comparison of capsule (B-C-D) durations.

Thanks a lot for your help.

Hi Siti Tay,
Thanks a lot for your help and answer,

There are two problems for using the Join with unchecking "Inclusive of A" and "Inclusive of B":
1- I have different size of capsules 1 hr to 5 hr. When I increase the amount of maximum capsule duration, Capsule C starts from capsule A that is one before the left side of C, see below:

A=amount of maximum capsule duration=2hr (I could not see a capsule between A1 and B1)
B=amount of maximum capsule duration=3hr (Now, Capsule C is incorrect)

I want something to join just two different capsules (A,B) before and after a capsule for any duration When capsule A is before B.

2-also in join, I have to select two different capsules, Sometimes I have to find capsule C between two capsules A when the duration is less than a certain amount.

Thanks again,

Javad

Hi,
How Can I select Capsule C those are between two different capsules (A and B)?
It means I am looking for Capsules of Cs those are started after capsule A and finished before capsule B.

Thanks