How can I join two tables of different lengths together in a clean manner?

[fiddycodes]

Table 1

name	school
chris	unc
john	UCF

Table 2

major

biology

math

chemistry

Desired output

name	school	major
chris	unc	biology
john	ucf	math
null or empty	null or empty	chemistry

So far, I haven't been able to get neither union nor join to achieve this. Please help!

[Luke_C · Accepted solution]

Hi @fiddycodes 

In this specific example the join multiple with 'join by record position' set will do this for you.

In your sample data you don't really have a field to do a true join on, so if this isn't exactly what you need can you describe your use case more?

[ShankerV · Accepted solution]

Hi @fiddycodes 

Please find the expected output.

[binuacs]

@fiddycodes One way of doing this

[fiddycodes]

This is exactly what I need. Didn't know about the join multiple. Thanks!