At 07:38 AM 3/3/2014, Jim Belisle wrote:
I did try a LEFT OUTER JOIN on two of the views as a test but it seemed
very SLOW so I am not convinced I did it correctly.
Any suggestions as to the best way to accomplish this?
Look at the UNION command to combine the columns and rows of two tables
or views into a new table or view.
HELP UNION
With a "properly defined and normalized database schema", you should be
able to accomplish your goal.
To learn and actually understand the use of UNION command in R:BASE, you
may explore the views defined in RRBYW18 sample database.
You may also refer to "Building Advanced Queries in R:BASE eXtreme 9.5".
From The Edge: www.razzak.com/fte
Topic: Building Advanced Queries in R:BASE eXtreme 9.5
Date Posted: 12/05/2013
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
