Framwork Manger and Select * from (Select)

[gosoccer]

Hi everyone,
I'm getting an error in Framework Manager when I execute the following:
This query contains an error and can not be executed.

select * from
(select A.CAR_ID from
CARS A )

It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 4: Syntax error near "end-of-statement".

Is there something I'm missing?

Thx alot for your time

[MFGF]

Hi everyone,
I'm getting an error in Framework Manager when I execute the following:
This query contains an error and can not be executed.

select * from
(select A.CAR_ID from
CARS A )

It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 4: Syntax error near "end-of-statement".

Is there something I'm missing?

Thx alot for your time

Can you explain what you are trying to achieve?

MF.

[gosoccer]

I'm trying to show values from two rows into one row. Please see:

http://www.cognoise.com/index.php?topic=29468.new;topicseen#new

So, I went after using Select * from (select but getting error)

I have the following scenario:

Case ID      Activity                 Date Updated
11111        Bill Paid                09/25/2015
11111        Received Bill         08/01/2015

Now, I need to show ON THE SAME ROW in Report Author:
CASE ID     Current Activity   Prior Activity   Date Updated
11111            Bill Paid               Received Bill    09/25/2015

So, Received Paid needs to show in the same Row showing the latest
information with the 09/25/2015 Date.
Thx for your time.