I have to give a search functionality, in that there is a dropdown called "STATUS",
which has values like, Leaves, Comp Off and Both,
For the Leaves I doing join between emp and leave,
For Comp off, join between emp and Comp Off, and both of these scenarios are working fine.
But for the Last option that is "Both", I want to do like,
Join betn Emp and Leave UNION Join Betn Emp and Comp Off.
So can anyone help me on this, is this doable in Yii?