API tools faq
paste
Advertisement
Guest User

union

a guest
Jun 3rd, 2015
215
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.58 KB | None | 0 0
raw download clone embed print report
  1. # pra facilitar
  2. SELECT
  3.     a AS CampoQueSoTemNaTabela1
  4.     '' AS CampoQueSoTemNaTabela2
  5.     '' AS CampoQueSoTemNaTabela3
  6.     tabela1.DATA AS dataGeralPraFacilitarOOrderBy
  7. FROM
  8.     tabela1
  9. UNION
  10. SELECT
  11.     '' AS CampoQueSoTemNaTabela1
  12.     b AS CampoQueSoTemNaTabela2
  13.     '' AS CampoQueSoTemNaTabela3
  14.     tabela2.data_louca_ai AS dataGeralPraFacilitarOOrderBy
  15. FROM
  16.     tabela2
  17. UNION
  18. SELECT
  19.     '' AS CampoQueSoTemNaTabela1
  20.     '' AS CampoQueSoTemNaTabela2
  21.     c AS CampoQueSoTemNaTabela3
  22.     tabela3.data_uhul AS dataGeralPraFacilitarOOrderBy
  23. FROM
  24.     tabela3
  25.  
  26. ORDER BY
  27.     dataGeralPraFacilitarOOrderBy
  28. LIMIT 6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!