Q:
SQL Mismatch in From Statement
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,
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:
Sep 17 2009 4:23 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
----------
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 ? :
FROM [Red and Black] RIGHT JOIN [72IN0140wOE] ON [Red and Black].Field1 = [72IN0140wOE].PN;
