Bill, I just created the view and it ran. It took some time even on a 2GHZ processor. I was wondering if after creating the view and paying the processing time, one could use a project statement and project a regular table, could you not? Phil
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Phil Nolette (NCS Group, Inc.) Sent: Thursday, October 25, 2001 10:58 PM To: [EMAIL PROTECTED] Subject: RE: Request for Help on Joins Thanks Bill. I was trying to use the generation of a new table so that I could pay the processing price up front (over 225,000 records). Thanks for your tip on the view. Phil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Downall Sent: Thursday, October 25, 2001 10:38 PM To: [EMAIL PROTECTED] Subject: Re: Request for Help on Joins 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. >
