MySQL Forums
Forum List  »  Italian

Re: unire 2 tabelle diverse
Posted by: Michele Abbondanza
Date: March 27, 2009 03:32AM

ciao!
che vuol dire fare n view di questo??
ma soprattutto, vuoi unire le due tabelle o fare una select semplicissima con il join tipo questa?

select a.id,a.prodotto,a.descrizione,b.caratteristiche from tab1 as a join tab2 as b on a.id = b.id_riferito_alla_tabella1 order by a.id,a.prodotto,a.descrizione,b.caratteristiche

Options: ReplyQuote


Subject
Views
Written By
Posted
9856
March 25, 2009 07:39AM
Re: unire 2 tabelle diverse
6440
March 27, 2009 03:32AM
4931
March 27, 2009 07:52AM


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.