Catlink has: ab_id catagory 56 animal 56 mineral 57 animal 58 animal 58 mineral 58 vegetable catagory has: animal vegetable mineral If 'where ab_id = 57' the resulting table would look like ab_id catagory .null. animal 57 mineral .null. vegetable OR 'where ab_id = 56' 56 animal 56 mineral .null. vegetableDoes that make any sense? From reading the docs it sounds like a right join would do that but I've not been able determine the correct sequence for the join.