Guest User

Untitled

a guest
Oct 21st, 2017
376
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. SELECT bokslut.omsatt,konkurs.url,konkurs.id,bokslut.YEAR,bokslut.kapital FROM konkurs INNER JOIN bokslut ON (konkurs.id = bokslut.konkurs_id AND bokslut.kapital<50) ORDER BY bokslut.omsatt DESC LIMIT 1
  2.  
  3.  
  4. +--------+------+------+---------+
  5. | omsatt | id   | YEAR | kapital |
  6. +--------+------+------+---------+
  7. | 546279 | 2582 | 2006 |  -52679 |
  8. +--------+------+------+---------+
Add Comment
Please, Sign In to add comment