Phil, "Join" is not an SQL statement. Both DB2 and R:Base have commands named JOIN, but they apparently have different syntax.
The syntax for the R:Base JOIN command would be: JOIN c_ctr USING c_comp WITH company USING mn_comp_id + FORMING c_all WHERE EQ You could get the same result set with a view: CREATE VIEW c_all (c_comp, c_ctr, c_ctr_nm, comp_nm) AS + SELECT c_comp, c_ctr, c_ctr_nm, comp_nm + FROM c_ctr, company + WHERE (c_ctr.c_comp = company.nm_comp_id) Bill On Thu, 25 Oct 2001 21:41:47 -0400, Phil Nolette \(NCS Group, Inc.\) wrote: >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. >
