How to apply unions and left joins in value set of table type?

Summary:
I want to show time shift on time card. For this purpose, I am creating a value set of Table type to get time shift based on the "RESOURCE_TYPE" column in PER_SCHEDULE_ASSIGNMENTS table. I want to apply a left join to get my desired results however I cannot type it in "where" field for value set. Looking forward to your response on how to write a left join in value set.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):