...
| Code Block | ||
|---|---|---|
| ||
SELECT id, fk_id, col1 FROM testTable1 WHERE fk_id = (select id from testTable2 where col = {customfield_10000}); |
| Info |
|---|
| If the parent field does not have associated a child custom field, there is no need to use to search by primary key. |
...
For those fields, the query should look like:
...