How can i get the same result in Progress 4gl?

[N.Molderf]

How can i implement query like this in Progress 4GL

SELECT field1, field2 FROM tbl1
WHERE field1 IN (SELECT Field1 FROM tbl2).


I have just 2 ideals one with temp-table and second with CAN-DO() function... but CAN-DO() function work with string, so i have to convert this field to string.. but this is bad idea... I am newbie in Progress.

Continue reading...