Re: Need SQL help

I get "Result of SELECT more than one row" error when I try to run this

On Tue, Dec 10, 2024 at 3:38 PM Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

SELECT * FROM MYTABLE1 WHERE
LOCATE_IN_STRING(
FIELD1,
(SELECT FLDA FROM MYTABLE2)
) > 0

On 12/10/2024 2:25 PM, Vinay Gavankar wrote:

I have a Table (MYTABLE1) with millions of rows with a field FLD1 (256
chars). I have another table (MYTABLE2) with about 100 rows with a field
FLDA (15 chars).

I want to get all records from MYTABLE1 where FLD1 has FLDA.
If FLDA has a value of 'ABCD' then
Select * from MYTABLE1 where FLD1 like %ABCD%
would probably do the job. But I need to do it for FLDA values of all the
records in MYTABLE2.

I know I haven't explained it properly so let me give an example:

FIELD1 in MYTABLE1:
Row 1 - ABCDEF;123456;GH;78
Row 2 - CDEFG;345678;
Row 3 - 345678;EWRT;9888
Row 4 - 85465;ASDFGT;QWERTY;85656

FLDA in MYTABLE2:
Row 1 - 123456
Row 2 - 345678

The final sql should return Rows 1,2,3 from MYTABLE1.

TIA
Vinay

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.