...
| Code Block | ||
|---|---|---|
| ||
SELECT id as pk, fk_id, col1 FROM testTable1 WHERE fk_id = (select id from testTable2 where col = {customfield_10000}); |
In the following example we assume the results of the following query will return multiple values for the parent field:
| Code Block |
|---|
select country, city from table; |