× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. June 2004

Is this possible in SQL

Hi,

we have an order line file and an order line text file like:

ORD LIN PRODUCT   (filea)
123     10       ITEM

and


ORD  LIN  TEXT    (fileb)
123      11    textaaaa
123      12    more text


Is it possible to join both files in SQL and get the following output:

ORD   LIN 
123       10         ITEM              (from filea)
123       11         textaaaa       (from fileb)
123       12        more text       (from fileb)

123       20         ITEM2

123      30         ITEM3
123      31         text


Regards,

Oliver

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.