Union Select Failing

[Bill Stanton]

Just trying to concatenate two tables with like fields. I get
an error message:

"The SELECT statement includes a reserved word or an
argument name that is misspelled or missing, or the
punctuation in incorrect."

Both tables DonRegFamCk and DonRegFam$$ define fields:
FundID, Amount, DOE, FamilyID
where FundID is the ID of the fund title in table "Funds".

SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID],
FROM [DonRegFamCk] INNER JOIN [Funds],
ON [DonRegFamCk].[FundID] = [Funds].[FundID],
UNION SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID],
FROM [DonRegFam$$] INNER JOIN [Funds],
ON [DonRegFam$$].[FundID] = [Funds].[FundID];

What am I missing?

Thanks,
Bill Stanton

 

[John Spencer (MVP)]

If that is your exact code, nothing is missing. However, you do have MORE than
you need.

You have an extraneous comma before the ON in both sections of the query and
another comma before the UNION and another before the FROM in each section.

SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID]
FROM [DonRegFamCk] INNER JOIN [Funds]
ON [DonRegFamCk].[FundID] = [Funds].[FundID]
UNION
SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID]
FROM [DonRegFam$$] INNER JOIN [Funds]

 

[Bill Stanton]

Thanks John.
Bill

If that is your exact code, nothing is missing. However, you do have MORE than
you need.

You have an extraneous comma before the ON in both sections of the query and
another comma before the UNION and another before the FROM in each section.

SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID]
FROM [DonRegFamCk] INNER JOIN [Funds]
ON [DonRegFamCk].[FundID] = [Funds].[FundID]
UNION
SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID]
FROM [DonRegFam$$] INNER JOIN [Funds]

Just trying to concatenate two tables with like fields. I get
an error message:

"The SELECT statement includes a reserved word or an
argument name that is misspelled or missing, or the
punctuation in incorrect."

Both tables DonRegFamCk and DonRegFam$$ define fields:
FundID, Amount, DOE, FamilyID
where FundID is the ID of the fund title in table "Funds".

SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID],
FROM [DonRegFamCk] INNER JOIN [Funds],
ON [DonRegFamCk].[FundID] = [Funds].[FundID],
UNION SELECT [Funds].[FundTitle],[Amount],[DOE],[FamilyID],
FROM [DonRegFam$$] INNER JOIN [Funds],
ON [DonRegFam$$].[FundID] = [Funds].[FundID];

What am I missing?

Thanks,
Bill Stanton