Are all these tables in Access? If so, I would recommend using the Access query builder to do most of the SQL for you. Just go into design view, show all the tables you want to select from and then choose the fields you want. Then switch to the SQL view and add the "where field = 'CRX1'" at the end of the statement. This way the statment will be built exactly how Access likes it.

Eva