September 29th, 2000, 03:57 PM
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.
September 30th, 2000, 11:07 AM
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.