Dear All,
  Sorry for bothering everyone.
  I am just working with MySQL but I have faced a problem:

I have a table with following problems:

TableA with following columns:
Name                    Cashincome             transaction_income

I cannot change the form of table.
If i wanna to have such output: (either cashincome or transaction_income will be 
filled, they will not be filled at the same time)
Name                      Incomes

which contain all data. How can I do this?

e.g.
Name                       Cashincome        Transaction_income
RecordA                    1234.00            
RecordB                                                    2230.00

Output
Name                        Income
RecordA                    1234.00
RecordB                    2230.00

Sorry for any incovenience caused.
Thanks anyway.

Yours sincerely,
Jason Chan
(Please reply to [EMAIL PROTECTED] or [EMAIL PROTECTED])

Reply via email to