Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- id, band_name, song_name, album_name, genre
- SELECT * from us_music, de_music where `genre` = 'punk'
- #1052 - Column 'genre' in where clause is ambiguous
- (SELECT * from us_music where `genre` = 'punk')
- UNION
- (SELECT * from de_music where `genre` = 'punk')
- SELECT * from us_music, de_music where `us_music.genre` = 'punk' AND `de_music.genre` = 'punk'
Add Comment
Please, Sign In to add comment