Thanks all for your responses and I can confirm Ed B's solution did what I needed.

I haven't explained very well - the second column isn't coming from another table, so there's nothing to join to - I am effectively wanting to create the second column...