hi, Y dnt you use join statement for this.[EMAIL PROTECTED] wrote: Hello,I have two simple queries which I am trying to combine usingbut it doesn't seem to work as expected.Query 1: SELECT requestid FROM users WHERE name = 'test'Query 2: SELECT count(*) FROM users WHERE name = 'test'IN XML:===
You'll have to do remapResults="true" in this case - because you are changing the result set in the same query.
Jeff Butler
On 6/15/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,I have two simple queries which I am trying to combine using but it doesn't seem to work as expected.
Query 1:
Problem solved: use and .
Aladin
>
> I have two simple queries which I am trying to combine using
> but it doesn't seem to work as expected.
>
> Query 1: SELECT requestid FROM users WHERE name = 'test'
> Query 2: SELECT count(*) FROM users WHERE name = 'test'
>
> IN XML:
> ===
> cacheMode
Hello,
I have two simple queries which I am trying to combine using
but it doesn't seem to work as expected.
Query 1: SELECT requestid FROM users WHERE name = 'test'
Query 2: SELECT count(*) FROM users WHERE name = 'test'
IN XML:
===
SELECT
count(*)
requestid
FROM users WHERE name = 't
