I am trying to write a query that merges 2 columns from different tables and show them as one column of data. Something like the following.
payables ID |check_no| amount| 3 |3478 | 67.00 | 4 |3489 | 98.00 | 8 |3476 | 56.00 | paychecks ID |check_no| amount 23 |3469 |498.00 | 34 |3502 |767.00 | 36 |3504 }754.00 | I am struggling to write a select query that gives me amounts and check numbers from both of the tables in the same column. Like the following: ID |check_no| amount| 3 |3478 | 67.00 | 4 |3489 | 98.00 | 8 |3476 | 56.00 | 23 |3469 |498.00 | 34 |3502 |767.00 | 36 |3504 }754.00 | Any help would be greatly appreciated. Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
