SQL Mismatch in From Statement

1,185 pts.
Tags:
AS/400 - DDS
SQL
What need to be done if an error message mentions "Mismatch in From Statesmen"?

It seems like I have not done any different then what I have done over the last numerous of queries that I have done. I started with an excel spreadsheet. I had to do some concatenation of the some columns. I then copied and pasted my final concatenation column into an access database. Save it and name it, "Red and Back". The other database is forming the AS400 and each of the database or table and queries work ok by them self, fine. What are some possible issues?

 SELECT [72IN0140wOE].PN, [Red and Black].Field1

FROM [Red and Black] RIGHT JOIN 72IN0140wOE ON [Red and Black].Field1 = [72IN0140wOE].PN;



Software/Hardware used:
MS Access98, AS400 Midragne, Windows XP,
ASKED: September 17, 2009  4:23 PM
UPDATED: September 18, 2009  11:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

The situation is I have an error message that mentions a mismatch in the from statement. What is a mismatch in the From statement? Can any one explain the different situations that would generate this type of error message? For a little background as to how the data was gathered. If I trace my action, I receive an excel spreadsheet. I needed to “text to column” or subdivide one column. Then add in a column to be able to generate a new number for multiple columns by concatenate. I then took the concatenated column and copied and pasted it into an access spreadsheet. Then when I used the Access dB as a part of my query I received the error.

———-

I’d say the JOINs are part of the FROM clause, so if you are joining on columns with different data types, it could cause a type ‘mismatch’ error.

Also, have you tried this ? :

<pre>FROM [Red and Black] RIGHT JOIN <b>[</b>72IN0140wOE<b>]</b> ON [Red and Black].Field1 = [72IN0140wOE].PN;
</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following