Coparing values from two tables

[Peony]

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

[jaibau1993 · Accepted solution]

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.

[Brett_Bleess]

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

[Peony]

It works! Thank you!

[Peony]

Done 🙂