Say I had two tables.
GLobalLists GID ItemName 1 Bulldog 2 Elephant 3 Crocodile CustomLists CID ItemName 10001 Aardvark 10002 Cane Toad 10003 Giraffe Is it possible to run a select that combines the two and then sorts on ItemName to give me a record set:- 10001 Aardvark 1 Bulldog 10002 Cane Toad 3 Crocodile 2 Elephant 10003 Giraffe Charlie
