Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.id, a.name, b.version
- FROM
- firstTable a,
- (SELECT name, version
- FROM secondTable b,
- (SELECT name, MAX(dateTime) as dateTime
- FROM secondTable
- GROUP BY name, versiune
- ) c
- WHERE b.name = c.name
- ) b
- WHERE a.name = b.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement