Hi Guys,
i have 2 tables:
and :
What i want is to get left join between AppVersion and System from TAble2ToJoin and get all matching records but inclusind relation "AnyVersion" to "All". So all versions (4.1,3.1, etc.) should be joined with "All" from Table2Join.
Result table should look like here:
Can you please help? I have no idea how to do this.
Best wishes,
Jacek
i have 2 tables:
and :
What i want is to get left join between AppVersion and System from TAble2ToJoin and get all matching records but inclusind relation "AnyVersion" to "All". So all versions (4.1,3.1, etc.) should be joined with "All" from Table2Join.
Result table should look like here:
Can you please help? I have no idea how to do this.
Best wishes,
Jacek