Re: Union query dropping "duplicate" rows

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 02/28/04

  • Next message: Don Jellie: "Re: Union query dropping "duplicate" rows" 
    Date: Sun, 29 Feb 2004 00:00:13 +0530

    >> The answer for your problem will be to use UNIAON

    spelling mistake above its UNION 

    -- 
Vishal Parkar
vgparkar@yahoo.co.in
  • Next message: Don Jellie: "Re: Union query dropping "duplicate" rows"

    Relevant Pages

    • RE: ORDER BY IIF(SoldUnits > 400, 0, 1), Description
      ... "Vishal Parkar" wrote: ... > Check if example shown in following query works for you. ... > select 'All about eve',810 union all ... >>> you post sample data and expected result set then it wd be easy to understand. ...
      (microsoft.public.sqlserver.datamining)
    • Re: flip the results
      ... Not enough info. if you are looking for sum of the columns you can have ... query as: ... union all ... Vishal Parkar ...
      (microsoft.public.sqlserver.programming)
    • Re: Union query dropping "duplicate" rows
      ... This is expected behavior of UNION clause. ... The answer for your problem will be to use UNIAON ...
      (microsoft.public.sqlserver.mseq)
    • Re: Order By with Union
      ... you can also try a query like: ... (Select A1, A2,A3 from TableA ... Union All ... Vishal Parkar ...
      (microsoft.public.sqlserver.programming)
    • Re: Help Finding records with matching columns
      ... if i understand your requirement correctly you can try the query given in ... int,col6 int) ... select 'A','B','C','e',97, 2 union all --row will be updated ... Vishal Parkar ...
      (microsoft.public.sqlserver.mseq)