MySQL Forums
Forum List  »  Italian

Re: JOIN
Posted by: Michele Abbondanza
Date: January 15, 2009 04:06AM

credo che il problema sia che togliere un valore da un alias equivalga a toglierlo dalla tabella.. ma fare qualcosa del genere no?

select v.cod_barre,
if((v.cod_barre)=931,'',v.cod_barre) cod_barre2 from vendita v



Edited 1 time(s). Last edit at 01/15/2009 04:25AM by Michele Abbondanza.

Options: ReplyQuote


Subject
Views
Written By
Posted
6046
December 29, 2008 04:36AM
Re: JOIN
2972
January 15, 2009 04:06AM


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.