I may be off-base, but it sounds to me like you want to produce a report with this information. In which case, you should probably use a report generator such as PowerBuilder or Crystal Reports (which I personally have worked with). These report generators allow you to create your queries and...
Terry - You're a genious! [thumbsup2]
For the record, I changed two things in your query to get the results I was looking for:
1> On the first SELECT statement, I changed
AND T.MOPCD != 'CK'
to
AND T.MOPCD != 'CK' AND T.MOPCD != 'BL'
2> On the last SELECT...
Thanks for the fast response.
If I add another UNION (I tried before writing to the list), none of the entries in the final merging includes entries from the MOPBL (because they are not in the MOPCK or MOPCD table?). I may have misinterpreted some online documentation because I understood UNION...
Any suggestions would be greatly appreciated. I need to have this in our next release by Monday. Thanks, Lisa
I am trying to accomplish a tricky merging of data. I have 4 tables - One master (TREQ), and 3 subtables (MOPCD, MOPCK, MOPBL). I currently have working a union statement that...
I have been in the computer field for almost ten years and have *JUST* finished earning my BSCS. I also am married, 3 children (11,4,4) and work full-time. I have been watching the job market to stay in touch and my opinion is that as more individuals apply for the same position, prospective...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.