Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have two table with a single field in each one. I need to compare values in Table 2 with values in Table 1. And if values from table 2 starting with the same characters as in the Table 1, then mark row with this value as 1. What is the better way to do it?
from the example, the Table 2 rows that contain "errr" and "weabcuy" will be without flag
Table 1 | Table 2 |
abc | abc |
ser | abc. |
der | abc-3 |
red | errr |
rew | derder |
ewr | rew-1 |
qwe | rew-2 |
weabcuy | |
rew-4 | |
qwe4 |
Hi!
Please, see the attached file. The key is to use the outer join so you can compare any value of the first table with any value from the second one. Let me know your doubts!
Regards,
Jaime.
Hi!
Please, see the attached file. The key is to use the outer join so you can compare any value of the first table with any value from the second one. Let me know your doubts!
Regards,
Jaime.
Natalia, did Jaime's post and example app get you what you needed? If so, do not forget to use the Accept as Solution button on his post to mark it as correct and give him credit for the help. If you are still working on things and have further questions, leave a new update on the thread for us.
Regards,
Brett
It works! Thank you!
Done 🙂