| Subject | Subselect with more than 1 fields |
|---|---|
| Author | Raigo |
| Post date | 2004-08-16T13:41:21Z |
How is made subselect query with more than one fields?
For example:
SELECT fkood, amnr
FROM koosseis
WHERE (fkood,amnr) NOT IN (SELECT fkood,amnr FROM isik)
gives me error "Token unknown line 3 char 13".
For example:
SELECT fkood, amnr
FROM koosseis
WHERE (fkood,amnr) NOT IN (SELECT fkood,amnr FROM isik)
gives me error "Token unknown line 3 char 13".