>Mr Edward Pikman,
>
>I actually not quite understand the command of LEFT JOIN
>can you give me the example or more specific detail
>
>Thank for your help

LEFT [OUTER] JOIN specifies that the query result contains all rows from the table to the left of the JOIN keyword and only matching rows from the table to the right of the JOIN keyword. The OUTER keyword is optional; it can be included to emphasize that an outer join is created.
Select Customer.*,Orders.ordernumber ;
From Customer LEFT JOIN Orders ON Customer.Id=Orders.CustId