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?

                                            

Reply via email to