Re: Can I do this in Query

Mark

this (or a variation) might be a plan but I need to check the join
properties to see if it is actually possible and can't get at a system
right now....

- create a file that has a one character field in it.
- add a "D" and an "X" record
- join the files (if possible) by substringing the first position
- include unmatched items
- break on the value in the joined to file (i.e. the single character field)

Hope this helps

Regards
Evan Harris

Need 3 separate sections (i.e. level break) in a single Query report as
follows

Section 1:  All items that do not have an X in pos 1 and do not have DSL
in pos 1-3

Section 2:  All items that have DSL in item # pos 1-3

Section 3:  All items that have X in item # pos 1

I know I could make it 3 separate queries with appropriate selection,
output to a file, then print vs that file but if at all possible would
like to do in 1 query…..

I can't figure a way to make it work….maybe it can't


Mark Allen
I.S. Manager
Wilkes Telephone & Electric
A Dycom Company
Phone: (706) 678-9565
Email: allenmark@nu-z.net
http://www.nu-z.net




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.