Re: SQL Question -- MIDRANGE-L

Subject: Re: SQL Question
From: Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Date: Wed, 5 Mar 2025 08:43:43 -0600
Auth-sender: vhamberg@xxxxxxxxxxxxxxx
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

Hi Greg

No matter what kind of OUTER JOIN, LEFT RIGHT or DULL, if you say SELECT * you'll get the doubling up of the same columns.

That's why I'd suggested using a CASE statement in the column list - with WHENs based on something like WHEN header IS NULL use detail WHEN detail is NULL use header else use header -
Does that seem like a possibility? Then you could use that SELECT as a CTE.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: SQL Question , Charles Wilt
Re: SQL Question , Vern Hamberg

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.