![]() LEFT OUTER JOIN SalesLT.SalesOrderHeader AS oh Replace the existing query with the following code: SELECT c.FirstName, c.LastName, oh.SalesOrderNumber For example, suppose you want to retrieve a list of all customers and any orders they have placed, including customers who have registered but never placed an order. In cases where a row in the outer table has no corresponding rows in the related table, NULL values are returned for the related table fields.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |