Advertisement
Guest User

Untitled

a guest
May 4th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. SELECT *
  2. FROM
  3. (
  4. SELECT case_id,diagnosis_title,updated
  5. FROM tbl_case
  6. order by updated desc
  7. ) as table1
  8.  
  9. UNION
  10.  
  11. select *
  12. FROM
  13. (
  14. select image_id,image_title,updated
  15. from tbl_image
  16. order by updated desc
  17. ) as table2
  18.  
  19. (SELECT case_id, diagnosis_title, ... FROM ...)
  20. UNION
  21. (SELECT image_id, image_title, ... FROM ...)
  22. ORDER BY ...
  23.  
  24. SELECT case_id,diagnosis_title,updated
  25. FROM tbl_case
  26. UNION
  27. select image_id,image_title,updated
  28. from tbl_image
  29. ORDER BY updated desc
  30.  
  31. CREATE TEMPORARY TABLE TempTable
  32. (id int, title varchar(100), updated tinyint(1));
  33.  
  34. INSERT TempTable
  35. SELECT case_id, diagnosis_title, updated FROM tbl_case ORDER BY updated DESC;
  36. INSERT TempTable
  37. SELECT image_id, image_title, updated FROM tbl_image ORDER BY updated DESC;
  38.  
  39. SELECT * FROM TempTable;
  40.  
  41. SELECT -1 as 'id' , 99999999999999 as 'sortalias' , now() as 'datum||date'
  42. UNION
  43. ( SELECT
  44. id
  45. ,unix_timestamp(datum) as 'sortalias'
  46. ,datum as 'datum||date'
  47. FROM kunde
  48. )
  49. order by sortalias desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement