Advertisement
rootUser

join multiple table myProject.sql (netbeans)

Jan 22nd, 2017
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. SELECT  memoryAll.MEMORYID,
  2.         memoryAll.MEMORYNAME,
  3.         memoryMoment.MEMORYMOMENTDATE,
  4.         memoryMoment.MEMORYMOMENTTIME,
  5.         memoryPlace.MEMORYPLACENAME,
  6.         memoryDescriptiON.MEMORYDESCRIPTIONFULL
  7. FROM memoryAll
  8.     JOIN memoryMoment
  9.     ON memoryAll.MEMORYID=memoryMoment.MEMORYID
  10.         JOIN memoryPlace
  11.          ON memoryAll.MEMORYID=memoryPlace.MEMORYID
  12.             JOIN memoryDescriptiON
  13.             ON memoryAll.MEMORYID=memoryDescription.MEMORYID
  14. WHERE memoryAll.MEMORYID=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement