table_two was not created, it was consumed by the join into table_one. So you should reference table_one for the results of the join.
Your join will behave like a concatenation because of the two different, hard coded, values of campaign. The count on the joined table will be the same as the counts on the original tables, one and two.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein