On Sun, Jan 5, 2025 at 1:58 PM Ricardo Mejias <ricardomej...@hotmail.com> wrote: > > 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.
Neither PSPP nor SPSS is a SQL database, so you cannot use SQL syntax with either one.
