In message <[EMAIL PROTECTED]>, Kevin J. Bowman <[EMAIL PROTECTED]> writes >My Query that does not work > >SELECT v_salesdetails.salesid,v_salesdetails.project, >v_salesdetails.responsible,v_salesdetails.statusname, >v_salesdetails.builder,v_salesdetails.status, >v_salesdetails.buildername, >IF project = '' THEN v_salesdetails.salesname > ELSE v_salesdetails.projectname AS salesname >END IF, > v_salesdetails.employeename >FROM v_salesdetails
How about: SELECT v_salesdetails.salesid,v_salesdetails.project, v_salesdetails.responsible,v_salesdetails.statusname, v_salesdetails.builder,v_salesdetails.status, v_salesdetails.buildername, if( project='', v_salesdetails.salesname, v_salesdetails.projectname ) AS salesname, v_salesdetails.employeename FROM v_salesdetails Not what I would call a newbie query... <G> -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
