Databasejoin element not populating with WHERE clause

[ontarget]

Hi I have a dbjoin element rendering as a dropdown which is working perfectly in J3 / F3 but identical settings in F4 Epsilon and J!4.3.3, php8.1 render only the "Please select".
Here is the where clause:

WHERE {thistable}.id IN
(
    SELECT `parent_id` FROM `course_categories_repeat_adminbase` WHERE `adminbase` = {$my->id}
)

I tried hardcoding my id into the where statement but still nothing shows in the DD
Here is a screen shot of the settings:


upload images
Thanks for any pointers.

 

[troester]

It seems you didn't select any value and label.

 

[ontarget]

Thank you Troester - that works - Weirdly I don't have values selected in my F3 J3 version and the DD gets populated...
See my F3 screen shots


upload images

 

[troester]

Strange...