Hi,

> 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
Server.
Upscene Productions
http://www.upscene.com