title: PostgreSQL column name as keyword in two table
body: <p>I have 2 table1 and table2 </p>
  
  <pre><code>table1
  id,desc
  
  table2
  id,t1_id,desc
  </code></pre>
  
  <p>how i can select row depending on desc="something" </p>
  
  <pre><code>select * from table1 t1 
  left join table2 t2 on t1.id=t2.t1_id 
  where t1.desc='something'
  </code></pre>
  
  <p>there is data in table 1 having desc "something" but its returning nothing</p>
  
  <p>i tried </p>
  
  <pre><code>where "desc"='something'
  </code></pre>
  
  <p>but giving </p>
  
  <blockquote>
    <p>ambiguous column desc error.</p>
  </blockquote>
  
  <p>how i can retrieve data from table 1 where desc='something' in postgreSQL</p>
  
  <p>many thanks...</p>