prefix with table name
688373Jun 14 2009 — edited Jun 14 2009I have a query which involves two tables with both have some common columns ..I thought that if we don't prefix column names with the table names we would get a "column ambigously defined" error so that we will know that we need to prefix that column name with the table name. But I am not getting this error and instead I am getting wrong results as a consequence of not prefixing the column name with the table name.
Is this usual? How do I avoid this?