Thanks Dan. Looks like that might get me halfway there. Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, February 19, 2014 1:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: View Design Question
If they are joined with an full outer join they will show blanks if the data shows in one table and nothing linked to the second table. Dan Goldberg -----Original Message----- From: Bruce A. Chitiea Sent: Wednesday, February 19, 2014 11:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - View Design Question I am currently producing a view: CommonAB A1 A2 B1 B2 ... from two temp tables: CommonAB A1 A2 CommonAB B1 B2 ... generated from base data. I'd like to produce a view that captures ALL data, looking like: Common AB A1 A2 -0- -0- Common AB A1 A2 B1 B2 Common AB -0- -0- B1 B2 Q: To do this, must I schematically redesign my temp tables as: Common AB A1 A2 B1 B2 Common AB A1 A2 B1 B2 ... and fill rows of the opposite columns with nulls: CommonAB A1 A2 -0- -0- CommonAB -0- -0- B1 B2 ... UNION these tables: CommonAB A1 A2 -0- -0- UNION ... CommonAB -0- -0- B1 B2 ... and then UNION this with the original view? And to populate the nulled columns of the temp tables, do I just use '-0-' in the SELECT statements? Thank you for your review and perspective, Bruce SafeSectors, Inc. --- 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. ================================================
