Receiving error on ColdFusion query of query
Posted on 2013-11-25
I have a query and a query of that query, something like the below, but I am receiving the following error. Could someone assist?
Query Of Queries syntax error.Encountered "1. Incorrect Select Statement, Expecting a 'FROM', but encountered '1' instead, A select statement should have a 'FROM' construct.
<cfquery name="firstQ" datasource="myds" username="user1" password="pass1">
select ID, Column1, Column2
From My table
<cfquery name="topfirstQ" dbtype="query">
select top 1 ID