OK, I just can't seem to get this. It should be super easy for most of
you to answer.

I have 2 tables that are similar in design. 1st is called
"Applications". The 2nd is called "ExtraApplications". They both
contain vehicle "Year", "Make", "Model" and "Engine" columns. I need to
pull the unique records from both tables simultaneously.

For example, I am currently pulling the "Year" from the Applications
table like this:

<cfquery name="GetYear" datasource="ds" username="un" password="pw">
SELECT DISTINCT Year
FROM applications
ORDER BY Year DESC
</cfquery>

Very simple. Now, how do I join the ExtraApplications table in that
same query to pull all unique records from both??

Thanks in advance!