|
|
Posted by Erland Sommarskog on 08/09/06 21:32
jason.langdale@gmail.com (jason.langdale@gmail.com) writes:
> Yes I did read the error message and it's as clear to me as it is to
> you. What is not clear to me is how to remedy it. Unfortunately, the
> same data is not contained in these two columns either.
Since you join over them they are. Or they are not, and you don't get
any rows back at all.
> I don't know if anyone here knows anything about Microsoft Dynamics GP,
> which is where these tables are coming from, but all three tables
> contain the same SOPNUMBE column but the rows in each table are unique.
> One his a historical table the other two are god knows what. Since on of
> these tables does not have all the fields I want to select, I can't do a
> simple union; which would be ideal for me. Maybe my entire approach is
> wrong. Have you got any ideas?
I don't know Microsoft Dynamics GP, I don't know what your specifications,
so my prospects to say whether you query will give you want you want are
utterly bleak.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|