Jun 17, 2010 #1 slowfish Programmer Joined Aug 21, 2009 Messages 28 Location GB Hi Is it possible to use CASE to work out which table to JOIN? Cheers