RE: Comparing data in two tables

Brigitta,
I love
Peter

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Birgitta Hauser
Sent: Thursday, 10 March 2011 7:03 p.m.
To: 'RPG programming on the IBM i / System i'
Subject: AW: Comparing data in two tables

Hi Mike,

try the following:

( Select * from Table1
Except
Select * from Table2)
Union
( Select * from Table2
Except
Select * from Table1)

If all rows in both tables are identical zero rows are returned.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Mike Wills
Gesendet: Wednesday, 09. March 2011 23:37
An: RPG programming on the IBM i / System i
Betreff: Re: Comparing data in two tables

This seems to work and could even be used outright in a stored
procedure. Thoughts?

select count(*) from (
select timesheet_code, count(timesheet_code) as count from (
select em_number, prhrt as timesheet_code, prhrsq as hours_summary
from mprlib.v_tshoursumm
union all
select em_number, timesheet_code, hours_summary from mprlib.v_reqhoursumm
order by em_number, timesheet_code ) table
where em_number = :id
group by timesheet_code
having count(timesheet_code) <> 2) table;

Is there a better way to do this?

--
Mike Wills
http://mikewills.me



On Wed, Mar 9, 2011 at 4:15 PM, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
wrote:

Exception join?

On 3/9/2011 3:50 PM, Mike Wills wrote:

What is MR?

For some visual reference here is what I am looking for:

This is what I need to make sure is true.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.