Re: MATCH FILES WITH FULL OUTER JOIN

[Ben Pfaff]

On Sun, Jan 5, 2025 at 1:58 PM Ricardo Mejias <ricardomejias@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.