Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT distinct STATIONS._id, nomstation FROM DESSERT, STATIONS
- WHERE DESSERT.idstation = STATIONS._id
- AND idligne = 'B2'
- AND position = (SELECT MAX(position) FROM DESSERT WHERE idligne = 'B2')
- OR nomstation = (SELECT nomstation FROM DESSERT, STATIONS
- WHERE DESSERT.idstation = STATIONS._id
- AND idligne = 'B2'
- AND position = 1)
Add Comment
Please, Sign In to add comment