title: MySql query column in field list is ambiguous
body: <p>I have OrderTbl table with OrdNo, OrdDate,  OrdState, CustNo and other columns and Customer table with CustNo, CustFirstName, CustState and other columns. And I need to select all of them but when I am writing a query </p>
  
  <pre><code>  select OrdNo, OrdDate,  OrdState, CustFirstName, CustState, CustNo from OrderTbl,Customer
  </code></pre>
  
  <p>MySQl gives me an error than mu CustNo column is ambiguous and I understand that it because CustNo in both tables..But what  can I do then?</p>