MySQL Forums
Forum List  »  Italian

Re: mysql - multi select da 2 tabelle (help)
Posted by: ehi jon
Date: December 08, 2010 12:42PM

Ciao, credo di aver fatto progressi... ma non sono riuscito ad arrivare al punto.
ora faccio un join con questa query:

SELECT `id_canzone`, `nome_canzone`, `genere` FROM `db_generi` INNER JOIN `db_canzoni` ON `db_generi`.`id_canzone` = `db_canzoni`.`id_canzone` WHERE `genere` LIKE 'rock' OR `genere` LIKE 'metal'

ma mi restituisce questo:
1_______________rock
1_______________metal
2_______________rock
3_______________rock
3_______________metal

invece vorrei solo:
1_______________nome_1
3_______________nome_3

Options: ReplyQuote


Subject
Views
Written By
Posted
4017
December 08, 2010 10:06AM
Re: mysql - multi select da 2 tabelle (help)
2591
December 08, 2010 12:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.