Re^5: More MySQL woes

You should always use the format
tablename.colname
for statements involving more than one table, otherwise the DB has to guess which one you mean when the tables have the same named column.
In fact, use a table alias for shorter code:

select t1.col1
from table1 t1, table2 t2
where t1.col1 = t2.col1
[download]

Comment on Re^5: More MySQL woes Download Code

Replies are listed 'Best First'.
Re^6: More MySQL woes by dsheroh (Monsignor) on Jan 21, 2008 at 17:39 UTC
Right, but my reading of jhourcle's post is that if you have columns named "id" in both tables, Oracle will automatically say "Oh, look - two columns with the same name! I'll be helpful and automatically JOIN them!" If this is the case (I'm not that familiar with Oracle, so I may be misunderstanding what he meant), then it doesn't matter how you refer to them in your query, the DB's misguided attempt to be "helpful" will still cause problems.	[reply]

Replies are listed 'Best First'.

Re^6: More MySQL woes
by dsheroh (Monsignor) on Jan 21, 2008 at 17:39 UTC

Right, but my reading of jhourcle's post is that if you have columns named "id" in both tables, Oracle will automatically say "Oh, look - two columns with the same name! I'll be helpful and automatically JOIN them!" If this is the case (I'm not that familiar with Oracle, so I may be misunderstanding what he meant), then it doesn't matter how you refer to them in your query, the DB's misguided attempt to be "helpful" will still cause problems.

[reply]