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])
