>I have a customer header and customer line items table.
>
>I want to pull the header and LATEST line item record joined
>together.
>
>How do I do this?

select * from customer c
left join OrderHeaders oh
on c.CustID = oh.CustID
where ordernumber =
(Select max(Ordernumber) from OrderHeader)