RepNum LastName FirstName Street City State PostalCode Commission Rate Item Item
ID: 3835658 • Letter: R
Question
RepNum LastName FirstName Street City State PostalCode Commission Rate Item ItemNum Description On Hand Category Storehouse Entity names Customer Customer Num CustomerName Street City State PostalCode Balance CreditLimit RepNuma Orders Order N OrderDate Column names Customer Num appear inside rectangles Orderline Order N Item Num Numordered Quoted Price An entity appears as a rectangle Line indicates a relationship Absence of a dot indicates the "one" part of the relationship Dot indicates the "many" part of the relationshipExplanation / Answer
This Query will retrieve all the customer names and mobile numbers and also ordernumber and order date for the customers who ordered anything and null values for those who doen't order anything.