Hi,
I was very glad to see the replies from you guys this
morning. The two suggested SQL queries did not return
the expected results, but will help me to explain the
problem I am facing further.
1) Josh suggested the following query. (I have made
minor changes by adding the table name to each f
James,
> but thats what:
> rec record
> select into rec id from table;
> return rec.id
>
> does
>
> my question was can i do this with a query built inside a string?
No. That's what I was talking about. You have to use the loop.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Eddie,
> My requirements involve several large tables. I have
> simplied scenario into the follow two fictional tables
> which describes the same requirements.
Keep in mind that a simplified example may not solve your real problem ...
> Basically I would like to display the latest
> submission f
Guys,
SQL spec aside, thinking about this from a strictly implementation/user point
of view:
(an keeping in mind that I think it's very important that we work out the
spec-correct behaviour for 7.4 and/or 7.3.3)
The particular case that Dan has raised is an issue for four reasons:
1) It looks t
