As an update to my earlier question, is it possible to have logic in
select statements including the join? ie,
select
IF(CHAR_LENGTH(broker)>0,broker,vendor) as company
from table 1
IF(CHAR_LENGTH(broker)>0,INNER JOIN tblBroker,INNER JOIN tblVendor)
Thanks.
On 11/28/05, SGreen@stripped <SGreen@stripped> wrote:
>
>
> Scott Klarenbach <doyouunderstand@stripped> wrote on 11/28/2005 01:58:22
> PM:
>
>
> > I'd like to do the following in my view
> >
> > select
> > fieldOne,
> > fieldTwo,
> > if(fieldThree.length>0) then fieldThree as Company
> > else fieldFour as Company
> >
> > from table;
> >
> > I realize this syntax isn't correct and length doesn't exists, but is
> > this possible? I've seen it done in SQLServer, but can't remember the
> > syntax.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
>
> LENGTH does exist (as a function):
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
>
> and here is how to use the IF() function:
> http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html
>
> I believe this is the equivalent statement you wanted:
>
> SELECT
> fieldOne,
> fieldTwo,
> IF(CHAR_LENGTH(fieldThree)>0,fieldThree,fieldFour) as
> Company
> FROM table;
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
