title: passing a parameter into a subquery
body: <p>i was wondering if it is possible to pass a parameter into a select subquery.</p>
  
  <p>What i want to do is collect some product data from one table and then crossref the weight of the item to it's carriage cost in a shipping table to return a cost.</p>
  
  <p>something like:</p>
  
  <pre><code>select cataloguenumber, productname, 
        (select shipping.carriagecost 
         from shipping 
         where shipping.carriageweight = weight) as carriagecost
  from products
  </code></pre>
  
  <p>Regards</p>
  
  <p>DPERROTT</p>