sort (union tables) desc

• vishalr

  SSC-Addicted

  Points: 409

  More actions

  April 16, 2003 at 1:31 pm

  #79843

  Hi,

  Iam doing 4 tables union and descending order by 2 fields.

  Here is sample query

  Select * from (

  Select equipno,activitydate,activitytime from Table1

  Union all

  Select equipno,activitydate,activitytime from Table2

  Union all

  Select equipno,activitydate,activitytime from Table3

  Union all

  Select equipno,activitydate,activitytime from Table4

  ) as k Order by Activitydate,activitytime desc

  But result is coming in Ascending order. If order by one field its giving correct result.

  What is the problem.

  Thanks

  Vishal

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  April 16, 2003 at 1:38 pm

  #454425

  Run this.

  Select * from (

  Select equipno,activitydate,activitytime from Table1

  Union all

  Select equipno,activitydate,activitytime from Table2

  Union all

  Select equipno,activitydate,activitytime from Table3

  Union all

  Select equipno,activitydate,activitytime from Table4

  ) as k Order by Activitydate desc ,activitytime desc

• vishalr

  SSC-Addicted

  Points: 409

  More actions

  April 17, 2003 at 5:32 pm

  #454643

  Thank you allen,

  Its working