Nested queries

Question

Question

john smith · Jan 2

Hi Guys,

This Nested query is not working for some reason, but they work fine when executing separately ?

select id from FDRD_Com.List where vehicle in (select Car from FDRD_Com.Prod where ProductLineName='Toyota' and Car is not null)

Thanks

Product version: Ensemble 2018.1

Discussion (3)2

Log in or sign up to continue

Robert Cemper · Jan 2

different approach:

SELECT LI.id from FDRD_Com.List LI
JOIN FDRD_Com.Prod PR
ON LI.vehicle = PR.Car 
WHERE PE.ProductLineName='Toyota'
AND PR.Car is not null  -- might be obsolete

0 0

score 0 · Answer 1 · 2025-01-02T15:00:18-05:00

IN is expecting a list.

Did you ever try

select id from FDRD_Com.List where vehicle IN
(select LIST(Car) from FDRD_Com.Prod where ProductLineName='Toyota' and Car is not null)

on the sub select ?

score 1 · Answer 2 · 2025-01-02T20:21:35-05:00

LIST didn't work but the Join did, thanks you very much Robert.

As I recall, Nest queries didn't work well if all in the old Cache versions so not sure if they improved it !?