I general use Impromptu and have the ability to create special table field joins, it appears I cannot do this in crystal. I was going to set up something in the select expert and I am having trouble finding the correct syntax. Basically the sql from Impromptu looks like this substr(table.field,15,6)=table.field. I cannot see how I would do this in crystal. Basically I need to say a certain field in one table is equal to another field in another table, position 15, 6 characters long.