× 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. March 2003

RE: SQL Question

make the first select in the union have the longer fileds. If the longer field comes from the first file for one column and the second file for hte other column, then append enough blanks to pad to the lenght you want. Substringing has too much risk of losing data.

HTH

Vern

At 02:01 PM 3/7/2003 -0800, you wrote: 
Thank you,  The union was what I was looking for...  If by chance my field
length are different, can I substring to make them match?

Thanks again, tim

> -----Original Message-----
> From: Buck Calabro [SMTP:Buck.Calabro@xxxxxxxxxxxx]
> Sent: Friday, March 07, 2003 1:57 PM
> To:   Midrange Systems Technical Discussion
> Subject:      RE: SQL Question
>
> Hi Tim!
>
> >What I would like to do, is create a view,
> >with a new key field, that joins these 2
> >tables into 1 table, for the purpose of my query...
> >here is the kicker...  the field names are not
> >the same...  there both character fields...



As an Amazon Associate we earn from qualifying purchases.

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

This mailing list archive is Copyright 1997-2024 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.