Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ometeam,fthg,awayteam,ftag AS results
- FROM (
- SELECT * AS TEAM,
- CASE
- WHEN hometeam LIKE 'Eibar' AND awayteam LIKE 'Alaves'
- END
- FROM sp1 AS tabla
- UNION ALL
- SELECT * AS TEAM,
- CASE
- WHEN hometeam LIKE 'Alaves' AND awayteam LIKE 'Eibar'
- END
- FROM sp1 AS tabla
- ) as total
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement