If you need to do a left outer join which is typically done between data tables, I suggest you use the database expert and create a command object. The command object is really a place for the SQL query which can include the LEFT OUTER JOIN.

 

If you simply want to join the column value to  to  = SEP here is an example

 

----------------------

ToText({Credit.Customer Credit ID}) & "= Sep"

 

returns  something like

 

"1234 = Sep"

-------------------------------------

 

Hope this helps.