question about subqueries
Created by: cryptix
I want to drop rows in tableA
that have no reference in tableB
(simple 1:n
) but I can't figure out the QL syntax for it.
Something like this would work in other sql's.
select id() from tableA where id() not in (select idA from tableB);
I also tried doing the sub-query in the from
field but I only get syntax error
's...
If it doesn't work (currently) I could work around it by doing it in two separate queries, I guess.
edit: guess I can't do the latter.. sql: converting Exec argument #0's type: unsupported type []int64, a slice
edit2: I could construct the query string with fmt
but that definitely feels to much like php... I hope there is another way and I just missed the important sentence in the docs.