Hi,
When trying to join a table in SQVI, i get the message "illegal join condtions". However if i try to do the same thing in ABAP, the compiler is fine with it.
SELECT bp_id
FROM /vwk/cms_dbbp001 AS bp_mast
JOIN /vwk/ccs_conbupa AS ccs
ON bp_mastbp_id = ccsbupa_id
INTO w_bp_id.
ENDSELECT.
The types of the field which i want to join are different (bp_mastbp_id is type DEC 10 and ccsbupa~id is Char 10).
Please advise how i can get SQVI Quickveiwer to accept the join, or explain why it thinks it is an "illegal join condtion". Many thanks,