"H L" <[EMAIL PROTECTED]> wrote on 04/03/2006 01:53:37 PM:
>
> >The solution is to redesign your tables. You need to split into
separate
> >columns the values you want to maintain. You do not want to keep the
"flat
> >file" design you are currently trying to use.
> >
> >CREATE TABLE calendar (
The solution is to redesign your tables. You need to split into separate
columns the values you want to maintain. You do not want to keep the "flat
file" design you are currently trying to use.
CREATE TABLE calendar (
objectid,
year,
dayofyear,
... other fields...
)
CREATE TABLE price
"H L" <[EMAIL PROTECTED]> wrote on 04/02/2006 11:51:48 AM:
> Hi, i have a problem to select sum from same table using UNION. The
key
> question is there a way of combining two questions in one so the
resulting
> objectid in query1 is only used in query 2 in a smart way. Eg. if only
one
> o
