Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- +--------+------+------+---------+
- | omsatt | id | YEAR | kapital |
- +--------+------+------+---------+
- | 546279 | 2582 | 2006 | -52679 |
- | 141268 | 2727 | 2005 | -21285 |
- | 109028 | 1204 | 2005 | -5815 |
- | 103786 | 4287 | 2005 | -2572 |
- +--------+------+------+---------+
Add Comment
Please, Sign In to add comment