query help

I am trying to write a query that merges 2 columns from different tables an=
d 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 num=
bers 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=3Dgcdmg-mysql-2@m.gmane.o rg

RE: query help

U0VMRUNUIElELCBjaGVja19ubywgYW1vdW50IEZST00gcGF5YWJsZXMgVU5J T04gU0VMRUNUIElE
LCBjaGVja19ubywgYW1vdW50IEZST00gcGF5Y2hlY2tzOw0KDQpSZWdhcmRz LA0KR2F2aW4gVG93
ZXkNCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogUmlj aGFyZCBSZWluYSBb
bWFpbHRvOnJpY2hhcmRAcnVzaGxvZ2lzdGljcy5jb21dDQpTZW50OiBUdWVz ZGF5LCBGZWJydWFy
eSAwOSwgMjAxMCA5OjIzIEFNDQpUbzogbXlzcWxAbGlzdHMubXlzcWwuY29t DQpTdWJqZWN0OiBx
dWVyeSBoZWxwDQoNCkkgYW0gdHJ5aW5nIHRvIHdyaXRlIGEgcXVlcnkgdGhh dCBtZXJnZXMgMiBj
b2x1bW5zIGZyb20gZGlmZmVyZW50IHRhYmxlcyBhbmQgc2hvdyB0aGVtIGFz IG9uZSBjb2x1bW4g
b2YgZGF0YS4gIFNvbWV0aGluZyBsaWtlIHRoZSBmb2xsb3dpbmcuDQoNCnBh eWFibGVzDQpJRCAg
fGNoZWNrX25vfCBhbW91bnR8DQozICAgfDM0NzggICAgfCA2Ny4wMCB8DQo0 ICAgfDM0ODkgICAg
fCA5OC4wMCB8DQo4ICAgfDM0NzYgICAgfCA1Ni4wMCB8DQoNCnBheWNoZWNr cw0KSUQgIHxjaGVj
a19ub3wgYW1vdW50DQoyMyAgfDM0NjkgICAgfDQ5OC4wMCB8DQozNCAgfDM1 MDIgICAgfDc2Ny4w
MCB8DQozNiAgfDM1MDQgICAgfTc1NC4wMCB8DQoNCkkgYW0gc3RydWdnbGlu ZyB0byB3cml0ZSBh
IHNlbGVjdCBxdWVyeSB0aGF0IGdpdmVzIG1lIGFtb3VudHMgYW5kIGNoZWNr IG51bWJlcnMgZnJv
bSBib3RoIG9mIHRoZSB0YWJsZXMgaW4gdGhlIHNhbWUgY29sdW1uLiAgTGlr ZSB0aGUgZm9sbG93
aW5nOg0KDQpJRCAgfGNoZWNrX25vfCBhbW91bnR8DQozICAgfDM0NzggICAg fCA2Ny4wMCB8DQo0
ICAgfDM0ODkgICAgfCA5OC4wMCB8DQo4ICAgfDM0NzYgICAgfCA1Ni4wMCB8 DQoyMyAgfDM0Njkg
ICAgfDQ5OC4wMCB8DQozNCAgfDM1MDIgICAgfDc2Ny4wMCB8DQozNiAgfDM1 MDQgICAgfTc1NC4w
MCB8DQoNCkFueSBoZWxwIHdvdWxkIGJlIGdyZWF0bHkgYXBwcmVjaWF0ZWQu DQoNClRoYW5rcywN
Cg0KUmljaGFyZA0KDQotLQ0KTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExpc3QN CkZvciBsaXN0IGFy
Y2hpdmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQpUbyB1bnN1 YnNjcmliZTogICAg
aHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1ndG93ZXlAZmZu LmNvbQ0KDQoNClRo
aXMgbWVzc2FnZSBjb250YWlucyBjb25maWRlbnRpYWwgaW5mb3JtYXRpb24g YW5kIGlzIGludGVu
ZGVkIG9ubHkgZm9yIHRoZSBpbmRpdmlkdWFsIG5hbWVkLiAgSWYgeW91IGFy ZSBub3QgdGhlIG5h
bWVkIGFkZHJlc3NlZSwgeW91IGFyZSBub3RpZmllZCB0aGF0IHJldmlld2lu ZywgZGlzc2VtaW5h
dGluZywgZGlzY2xvc2luZywgY29weWluZyBvciBkaXN0cmlidXRpbmcgdGhp cyBlLW1haWwgaXMg
c3RyaWN0bHkgcHJvaGliaXRlZC4gIFBsZWFzZSBub3RpZnkgdGhlIHNlbmRl ciBpbW1lZGlhdGVs
eSBieSBlLW1haWwgaWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyBlLW1haWwg YnkgbWlzdGFrZSBh
bmQgZGVsZXRlIHRoaXMgZS1tYWlsIGZyb20geW91ciBzeXN0ZW0uIEUtbWFp bCB0cmFuc21pc3Np
b24gY2Fubm90IGJlIGd1YXJhbnRlZWQgdG8gYmUgc2VjdXJlIG9yIGVycm9y LWZyZWUgYXMgaW5m
b3JtYXRpb24gY291bGQgYmUgaW50ZXJjZXB0ZWQsIGNvcnJ1cHRlZCwgbG9z dCwgZGVzdHJveWVk
LCBhcnJpdmUgbGF0ZSBvciBpbmNvbXBsZXRlLCBvciBjb250YWluIHZpcnVz ZXMuIFRoZSBzZW5k
ZXIgdGhlcmVmb3JlIGRvZXMgbm90IGFjY2VwdCBsaWFiaWxpdHkgZm9yIGFu eSBsb3NzIG9yIGRh
bWFnZSBjYXVzZWQgYnkgdmlydXNlcyBvciBlcnJvcnMgb3Igb21pc3Npb25z IGluIHRoZSBjb250
ZW50cyBvZiB0aGlzIG1lc3NhZ2UsIHdoaWNoIGFyaXNlIGFzIGEgcmVzdWx0 IG9mIGUtbWFpbCB0
cmFuc21pc3Npb24uIFtGcmllbmRGaW5kZXIgTmV0d29ya3MsIEluYy4sIDIy MCBIdW1ib2x0IGNv
dXJ0LCBTdW5ueXZhbGUsIENBIDk0MDg5LCBVU0EsIEZyaWVuZEZpbmRlci5j b20NCg==