Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Query question

Author  Topic  lionell Starting Member 1 Post Posted - 2001-11-07 : 05:21:42 SELECT consultants.voornaam INTO :match.MATCHSCHERM FROM consultants WHERE personeelsnummer in (SELECT distinct consultant_profielen.con_personeelsnummer FROM consultant_profielen WHERE mi_mcode in (select mi_mcode from aanvraag_profielen where an_aanvraagnummer = :aanvragen.aanvraagnummer)); This is the query which has to display something. When it finds two or more consultant_profielen.con_personeelsnummer it gives an error. When I add consultants.achternaam for example it also gives a error. This is all done with developer forms. It has to displa one or more database items it finds. Please help me find the right code.