use real tables for the test to get self-join we need

temporary tables can not be used twice in the same query