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