Joins with WHERE clause

I'm having trouble with a join query. In this example there are two tables that will be queryed with $pmsid as the common field. That much I have figured out.

I would like to add a clause that will only list data where $compatible = 'y'. I've tried a few things, with this example being the one I thought would surely work:

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>SELECT * FROM ver,pms WHERE ver.pmsid=pms.pmsid AND ver.compatible = 'y' ORDER BY pmsname, ver[/code]

When this query is performed, no results are returned (there should be over 100).

Any help is appreciated.
- Mike

Resolution:

Changed the ORDER BY clause:

ORDER BY pms.pmsname, ver.ver

No rows were returned because there was not a table association with the ORDER BY fields.