مشکل در select

[zoofa]

سلام دوستان


select tbl_factor_articles_dynamic.factor_code , date_now , (select name from tbl_debtors where mycode = account_code)as name , (select name from tbl_creditors where mycode = account_code )as name , if ( flag = 1 , tedad , 0) as creditor , if ( flag = 0 , tedad , 0 ) as debtor , flag
from tbl_factor_articles_dynamic inner join tbl_factor_subject_static on tbl_factor_articles_dynamic.factor_code = tbl_factor_subject_static.factor_code
where article_code =400007


نتیجه:
55809

می خام اون قسمتی که قرمز کردم تو کوئری ( دو تا فیلد name ) تو نتیجهبه یکی تبدیل بشه
یعنی اگه بدهکار یا بستانکار بود هردوش داخل یکی بیاد

[amiramt]

select tbl_factor_articles_dynamic.factor_code , date_now , if ( account_code like '6_____', (select name from tbl_debtors where mycode = account_code) , (select name from tbl_creditors where mycode = account_code) )as NAME, if ( flag = 1 , tedad , 0) as creditor , if ( flag = 0 , tedad , 0 ) as debtor , flag as remain_article from tbl_factor_articles_dynamic inner join tbl_factor_subject_static on tbl_factor_articles_dynamic.factor_code = tbl_factor_subject_static.factor_code where article_code =400007

برو حالش را ببر