Hello All,
Not being a SQL whiz I've got a "surely" simple problem, can someone
help?
I have an array of objects and wish to select on a child table if its
parent is in the array of objects, how do I write this in SQL?
I want in logic terms this...
SELECT * FROM Table WHERE Field1=:VAR1 OR $D(:ARRAY(Parent->ID))
But ofcourse $D isn't an SQL function! I can't figure how to do it in SQL..
Any help much appreciated.
Thankyou
