Assuming the original table has two records in it is a big thing here too. The answer is notably different when you only start with one record. I am generally against being clever with "non standard" or "non generally accepted" syntax for the sake of acadamia. In this case the natural join.