| Problem in join relation [message #227710] |
Thu, 29 March 2007 02:36  |
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
|
Senior Member |
|
|
hii all
I am joining two block by a relation
in the relation property on the block leverl
ITFXXXXXX.GBR_CODE = ITFDTXXXX.ITF_GBR_CODE AND
ITFXXXXXX.GBR_GCO_CODE = ITFDTXXXX.ITF_GBR_GCO_CODE AND
ITFXXXXXX.NO = ITFDTXXXX.ITF_NO AND
ITFXXXXXX.GST_CODE_FROM = ITFDTXXXX.GST_CODE AND
ITFXXXXXX.GST_CODE_TO = ITFDTXXXX.GST_CODE_TO
it gives me an error of
error while parsing join condition
although when i try this condition in sql
it doesnot result an error
Thanks for everyone helped and helping me
|
|
|
|
| Re: Problem in join relation [message #227858 is a reply to message #227710] |
Thu, 29 March 2007 19:07  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Did you reread your post before submitting it? What does 'error of error' mean? Please post the error code and error message.
Check your datatypes. First, in the 'where' clause. Then compare the 'into' field datatypes against the 'select' field datatypes. [Okay, the second part is not applicable in this case. Sorry.]
David
[Updated on: Thu, 29 March 2007 19:07] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
