title: SELECT single row from child table for each row in parent table
body: <p>I am trying to get only one row from child table for each parent row with child fields included, I have been trying with GRUOP BY but with no success :(
  Here is my initial SELECT</p>
  
  <pre><code>SELECT pID, lastname 
   FROM parent 
    LEFT JOIN 
     (SELECT cID, pID, phone, company, title FROM child) as child 
     ON parent.pID = child.pID
  </code></pre>
  
  <p>Here is the tables strcture</p>
  
  <pre><code>CREATE TABLE parent (
      pID Counter(1,1) PRIMARY KEY,
      firstname VarChar(24) DEFAULT '',
      lastname VarChar(20) DEFAULT ''
  );
  
  CREATE TABLE child (
      cID Counter(1,1) PRIMARY KEY,
      pID int DEFAULT '0',
      phone VarChar(16) DEFAULT '',
      company VarChar(24) DEFAULT '',
      title VarChar(24) DEFAULT '',
      address TEXT
  );
  </code></pre>