Subject Re: [firebird-support] Subselect with more than 1 fields
Author Martijn Tonies

> How is made subselect query with more than one fields?

You can't.

> 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".

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions