The command:
select FirstName from MyList
result is 100 records

The command:
select FirstName from YourList
result is 200 records

The command:
select FirstName from MyList;
union select FirstName from YourList
result is not 300 records it is 50 records. Only the unique FirstName

I am seeking the syntax which will give me all 300 records.