Thank you both for the replies. I obviously have some things wrong, and I'll have to masticate on the answers. AIUI, the foreign key references are not an issue for me since I always specify the column name. Thanks again, Jim ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match