Left joining with LIKE behavior

Comments

1 comment

  • Avatar
    Marc Saunders

    What about creating a custom field against each record with the value you are expecting for the next year, if that is possible then you can just do a match, or even do a count of how many records have that entry in the job ref column then you just have the value if it has a followup entry or not?

Please sign in to leave a comment.