Abdelhak Khedhiri Posted January 13, 2022 Share Posted January 13, 2022 Hello I need to join two tables by using 2 columns (%1,%2)from the first one and 1 column (%3) from the second one. Table 1: column1 contain data like PRJCDE and column 2 contain date like PRJCDE Table 2 : column1 contain data like HOWPRJCDEPRJCDE to joint de two tables i need to extractPRJCDEPRJCDE from column of table 2 (%3) and concatenate %1 and %2 of table 1 in order to set in freehand field of the join Substring(HOWPRJCDEPRJCDE fom 4th position until the end to the string) = concatenation (%1 and %2). I tried several text function Mid, lef, Right etc ... bu i continue to have error and the join can't be created. Many thanks for your help and advice Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now