Re: EXPLAIN question

[Dan Nelson]

In the last episode (Jul 20), Ravi Raman said:
> ok, first actual question to the list, hope someone can help:
> the following query -
>
> select pn.number, c.ID, c.cost, c.days_valid, c.description from
> pinnumbers pn, cardtype c where pn.cardtypeID = c.ID and pn.tmaster = 0
> order by c.ID, pn.number
>
> returns: 55033 rows in set (4 min 10.11 sec)

Are pn.cardtypeID and c.ID declared the same?  That can sometimes cause
problems.

-- 
	Dan Nelson
	dnelson@stripped