Please Help... [CANCEL]

• • Reply

  18 years ago

  by Dodger

  Glen Ainscow

  Cape Town, South Africa

  Joined 19 years ago

  Hey All,
  

  
  Is it possible to select a random record of a table where the record has no related records in an inner joined table?
  

  
  ie...
  

  
  [Table 1. - Main Table (members)]
  

  
  

  
  ID | Firstname | Lastname

  
  

  
  01 | James      | Bond
  02 | Paul         | McMahon
  03 | Sean        | Connor

  
  

  
  

  
  [Table 2. - Related Table (Orders for example)]
  

  
  

  
  ID | Order #   | Product

  
  

  
  02 | ON-1457  | Cheese
  02 | ON-1457  | Bread
  05 | ON-1590  | Milk

  
  

  
  

  
  So we know Paul has made an order (for Cheese & Bread), now how can we select (randomly) "James" or "Sean" as they have no orders?
  

  
  Does this make any sense?
  

  
  TIA.
  

  
  

  Report abuse