Help with a query

[Aaron]

Ok here is table one:

PropID VersionID CatID Item Type
dbtester 1 1 Apple 1
dbtester 1 1 Ford
2
dbtester 1 2 Chevy 2
dbtester 1 1 Blue
3
dbtester 1 1 Large 4
dbtester 1 2 Small 4

Here is Table 2 (The # under each item corresponds the CatID in table
one...no number means null)
PropID VersionID Client Fruit Car Color Size
dbtester 1 Bob
1 2
dbtester 1 Amy 2
dbtester 1 Sam 1
dbtester 1 Tom
1 1

Trying to get the output to be:

PropID VersionID Client Fruit Car Color
Size
dbtester 1 Bob
Apple Small
dbtester 1 Amy Chevy
dbtester 1 Sam Blue
dbtester 1 Tom
Ford Large



PropID and VersionID are variables I input each time the query runs.

Thanks very much!!