sql server data mining: Hello!
I have to make a query,that combines two views,and gives
me result about IDs and Origin!
However,one of my two views has for one ID number,2
different Origins!
As a result,when I run my query,I get a number of results
that is far greater than it should be, because it returns
twice information about one ID.
For example,I have..
ID Origin
CA150 Milk
CA150 Oil
…
and when I want in my final query to have all IDs with
their Origins,I have duplicate values!
Do you know how I can fix that?DISTINCT doesn’t work,and
I’m trying UNION,but I haven’t made it so far!
Thank you very much for your help!
George Antoniou

George,

can you post table structure/sample records and expected result set that you are
looking for.

--
- Vishal