multiple query to produce one entry for each customer

[FB1]

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

 

[FB1]

Thank you very one
manage to sort out the issue