MATCH FILES WITH FULL OUTER JOIN

[Ricardo Mejias]

I found this explanation of FULL OUTER JOINS syntax on: https://hightouch.com/sql-dictionary/sql-full-join

The syntax for a SQL FULL JOIN operation is as follows:

SELECT column_list
FROM table1
FULL JOIN table2 ON table1.column = table2.column;

• column_list: A list of columns to retrieve from the joined tables.
• table1 and table2: The names of the tables to be joined.
• column: The common column or key that relates the tables.

I implemented it on my code as:

MATCH FILES                                                             

SELECT      CountyCode VoterID LastName FirstName MiddleName ResidenceAddress1 ResidenceAddress2 ResidenceAddressCity ResidenceState Gender Race BirthDate RegistrationDate Party20241112 VoterStatus DaytimeAreaCode DaytimePhonenumber Emailadress Party_20241022                                                           

                                                                  

FROM  /FILE = "F:\External Drive for PSPP Data\FloridaTotalsFiles\SelectedFields_20241112.sav"                                                        

FULL OUTER JOIN /FILE = "F:\External Drive for PSPP Data\FloridaTotalsFiles\VoterIDParty_20241022.sav"                                                      

/BY VoterID.

And this is its Output

MATCH FILES   

Untitled.sps:2.1: error: MATCH FILES: Syntax error expecting FILE or TABLE.

    2 | SELECT    CountyCode VoterID LastName FirstName MiddleName ResidenceAddress1 ResidenceAddress2 ResidenceAddressCity ResidenceState Gender Race BirthDate RegistrationDate Party20241112 VoterStatus DaytimeAreaCode DaytimePhonenumber Emailadress

Party_20241022

      | ^        

Untitled.sps:2.1-2.6: error: SELECTPRED: SELECTPRED is not yet implemented.

    2 | SELECT    CountyCode VoterID LastName FirstName MiddleName ResidenceAddress1 ResidenceAddress2 ResidenceAddressCity ResidenceState Gender Race BirthDate RegistrationDate Party20241112 VoterStatus DaytimeAreaCode DaytimePhonenumber Emailadress

Party_20241022

      | ^~~~~~           

SELECT      CountyCode VoterID LastName FirstName MiddleName ResidenceAddress1 ResidenceAddress2 ResidenceAddressCity ResidenceState Gender Race BirthDate RegistrationDate Party20241112 VoterStatus DaytimeAreaCode DaytimePhonenumber Emailadress

Party_20241022

Untitled.sps:4.1-4.4: error: Unknown command `FROM'.

    4 | FROM      /FILE = "F:\External Drive for PSPP

Data\FloridaTotalsFiles\SelectedFields_20241112.sav"

      | ^~~~

FROM  /FILE = "F:\External Drive for PSPP Data\FloridaTotalsFiles\SelectedFields_20241112.sav"

FULL OUTER JOIN /FILE = "F:\External Drive for PSPP

Data\FloridaTotalsFiles\VoterIDParty_20241022.sav"

/BY VoterID.

Is this not working because it has not yet been implemented?

Or do I need to make some changes to my implementation for it to work?