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. ================================================
