if I am selecting from one table the records that are related to an id of another table what is the best way to do this? Andrew