Yep, tried that too. Another thing I just noticed is that it does not like the dot notation as in dbr.PrimaryID or whatever. It gives this error:
<ERROR> Query Manipulation Error Code = 0 Invalid SQL SQL = "SELECT dbr.* FROM dbResults dbr INNER JOIN verityResults vr ON vr.key=dbr.PrimaryID" Data Source = "" The error occurred while processing an element with a general identifier of (CFQUERY) </ERROR> George On 5/3/05, Pascal Peters <[EMAIL PROTECTED]> wrote: > Did you try > SELECT dbr.PrimaryID AS PrimaryID, vr.Score AS Score ... > > Pascal > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205381 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
