I didn't look closely but why can't you always include that join in the query?

>>What's JOIN condition for the Groups table ?
>
>inner join UsGrLink on
>Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk = UsGrLink.cUsGrLink_pk inner join groups on UsGrLink.iGroupId = Groups.iID
>
>>>
>>>I have a queue assignment form that allows to get accounts from UNASSIGNED queue or from a particular investigator.
>>>
>>>In the first case one of the condition will look like:
>>>
>>>and Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk IS NULL, in the other case the condition would be
>>>Trans.cCommissioned_Owner = m.tcUserID
>>>
>>>Now, in the second case I'd like to join to another table (Groups) and get some fields from it. How can I make this generic, e.g. my routine doesn't know which type of WHERE condition I'm passing (I'm just passing lcWhereStr) for my select statement? In other words, I want to join with Groups table if cCommission_Owner_UsGrLink_fk is not null, otherwise I want to just put null placeholders instead of the fields.
>>>
>>>Thanks in advance.