Load Table File w/ as specific value in Field

[#1]

I have two tables:

Fruit	Color
Apple	Red
Banana	Yellow
Orange	Orange

Table 2
X
Y
Z

How do I load Table 2 with all rows, color = red for example?

Thanks in advance!

-Jason

[Oleg_Troyansky · Accepted solution]

something like this:

Load

     Field1,

     'Red' as Color

FROM/RESIDENT

     ...

[#3]

Awesome, thank you Oleg!