hi all
Query one
need to pull the last record from multiple sale table b  which is joined to 1 to 1 customer table a

only need to see last data entry against each customer.

query two

customer table a 1to1
issue table b multiple entry

need to create a query that joins both to show one complete entry to report on.

Except for a little issue where i need 3 fields to show and they are not always populated at the same time, but are kept in the same table

i.e.

oid   nameid   car   van         lorry  date
1      12       yes   [null]      yes   01/01/2012
2       12      [null] yes       [null]  12/12/2011
34      11       yes   [null]     [null] 12/12/2011
35      11     [Null]   Yes        [null]    11/11/2011
56      11      [null]  [null]      yes     10/11/2011


would like to see

nameid   car   van         lorry  
12        yes   yes        yes
11        yes   yes        yes

You help will be most appreciated