This content has been marked as final. Show 5 replies
i have concatenated 1 & 2 tables, as they have similar fields , except 1..
Table 1 - Orders
Table 2 - Delivery
Table 1 - Department - example Catering
Table 2 - Dept - example CAT
I need to link these but having an issue
i have left join a Table 3- DepartmentLink
Department - example Catering
DeptCode as Dept - example CAT
is there a way of if CAT is found rename as Catering so a link is made?