I know that I can do inner and (unchecked inner) for left outer joins? I have used those successfully. Are any other joins supported?
Is there a way to concatenate multiple tables or files together?
Is tUniqueRow the best way to check for an remove duplicates?
Brilliant thanks... is there a way to do that if you have many files ... I've got about 50.