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
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
