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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Scott Klarenbach <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
