I have checked every possible reference including e-mails, rsyntax, and even
a book by Tom Goodell and I am flat begging for help. It is such a common
used command on DB2 but I can not get it to work on RBase.
I have two tables that I am trying to join: c_ctr and company.
Table C_CTR has a whopping three columns (c_comp, c_ctr, and c_ctr_nm. they
are all text)
Table COMPANY has two columns (nm_comp_id and comp_nm. they are also text
and both are length 4)
At R> I typed the following: join c_ctr using c_comp with company using
nm_comp_id forming c_all where c_comp = nm_comp_id
= > I consistently get -ERROR- Syntax is incorrect for the comman JOIN
(2045)
This is a simple join used in debugging. I have a more complex join in
queue but if I can not get these two dumb little tables to join, I should
not go any further. Do you have to set some setting in order to be able to
do joins?
Phil
winmail.dat
