> SELECT * FROM iopoints WHERE systemid=123 AND enclosureid='ab' AND pointid=56
A slight variation of the syntax would be:
select * from iopoints where (systemid, enclosureid, pointid) = (123,'ab',56);
this table and fields sounds alot like a control system be being modeled. :-)
Regards,
Richard Broersma Jr.