title: can any one help me what would i do here?
body: <p>I have 2 tables. My table structure is like this:</p>
  
  <pre><code>Table 'customer' 
  ( 
      cust_id (PK), 
      cust_name, 
      cust_balance 
  ); 
  and Table 'account' 
  ( 
      acc_id (PK), 
      cust_id(FK) --relating to customer table  
  ); 
  </code></pre>
  
  <p>customer data:</p>
  
  <pre><code>name  cust_id
  scott c100 
  ford  c200 
  </code></pre>
  
  <p>account data:     </p>
  
  <pre><code>scott personal a100 
  scott joint    a300
  ford  personal a200
  ford  joint    a300 
  </code></pre>
  
  <p>Then what will be the value in account table's cust_id column?? If I am entering Scott's id then while querying it will show that only Scott has 2 accounts but that's not true, Ford also has 2 accounts. So how do I do this?</p>