Access SQL   ›   Tags   ›   unon

Tags
Author: accessman - Replies: 1 - Views: 380
Unon Sorguda Order By Desc Problemi
iyi günler
Visual Basic
  1. SELECT Format([zaman],"dd-mmm-yyyy") AS Deyim1 FROM tCasus GROUP BY Format([zaman],"dd-mmm-yyyy") ORDER BY Format([zaman],"dd-mmm-yyyy") DESC
  2.  UNION
  3. SELECT Format([openTime],"dd-mmm-yyyy") AS Deyim1 FROM itLog GROUP BY Format([openTime],"dd-mmm-yyyy") ORDER BY Format([openTime],"dd-mmm-yyyy") DESC
  4.  UNION
  5. SELECT Format([addTime],"dd-mmm-yyyy") AS Deyim1 FROM itLogMuayene GROUP BY Format([addTime],"dd-mmm-yyyy") ORDER BY Format([addTime],"dd-mmm-yyyy") DESC;


sorgu