can anyone see whats wrong with this piece of code?

<cfcontent type="text/vnd.wap.wml"><?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
"http://www.wapforum.org/DTD/wml_1.1.xml">


<cfquery name="listauction" datasource="#dsn#">
SELECT *
FROM stock
WHERE AuctionCar = 1
</cfquery>

<cfquery name="listfavmake" datasource="#dsn#">
SELECT u.favMake, s.id, s.makeID, s.modelID
FROM
userPref u LEFT JOIN stock s
ON u.favMake=s.makeID

</cfquery>

<wml>


<card title="" id="menu">
<p align="center">
Logged in as <cfoutput>#session.uname#</cfoutput><br/>

</p>
<p>Cars currently available:<br/></p>


<p><cfoutput query="listauction">#id# #makeID# #modelID#<br/></cfoutput></p>
<p><cfoutput query="listfavmake">#s.id#<br/></cfoutput></p>



</card>


</wml>


Basically two SQL queries and two outputs. For some reason it doesn't like the query with the join, when i take it out the page works fine. Are there SQL limitations to WML pages? Because that query works fine on a normal coldfusion page I think...

Have you verified the query?

Generally, the syntax for table aliases is


Does that work?