Today I find out not a 'UNION' problem!  

The statement is as this

Select a.item_number,a.qty*b.factor from table A as a,table B as b
Where a.item_number=b.item_number

-----Original Message-----
From: Brian Perry [mailto:bperry@d...] 
Sent: Monday, July 22, 2002 7:22 PM
To: sql language
Subject: [sql_language] Re: UNION statement

I would try UNION ALL.

Without the ALL keyword, duplicate rows are (automatically) eliminated.