>>>>>Hello
>>>>>I have three table with a common field. Can I set the relation between these three tables and their common field? I am used to doing
>>>>>this with 2 but not 3. Is there some way I can establish a "relationship" between 12 tables, each of which has a common field.
>>>>
>>>>I find using SQL and cursors much easier than anything involving SET RELATION, SET SKIP etc. I haven't used the latter commands for many years.
>>>
>>>I still use them to verify in first step visually if I generated large amounts of data - second step is generating descriptive stats across linked tables. Often you see your gotchas in the browse relationships test without having to wait for heavy join action ;-)
>>
>>I have 12 tables, actually more, and each one has a common field, called mDate, in this format: 201211281730, which includes the year, the month, the day, the hour, and the
>>minute (in 15 minute segments). In addition, each table has a numeric field, called mRating. What I really want to do is to get the sum of all of the mRating's fields, for each particular
>>hour. I really am not sure how to do this with sql. The following must be a step in the wrong direction and will take a really, really long time.
>>
>>
>>SELECT table1.mRating + table2.mRating as SumRating FROM table1, table2
>>
>>
>>Is there a better quicker way to do this with SQL? I know I can use set relation with 2 tables. But the help in VFP 9 does not say much about additive, although I
>>suppose it must be what it sounds like.
>>
>>Thanks, Steve
>
>
>CLOSE ALL
>SELECT 1
>USE table4
>INDEX on mindex TO g
>SELECT 2
>USE table5
>INDEX on mindex TO gg
>SELECT 3
>USE table6
>INDEX on mindex TO ggg
>SELECT 4
>USE table7
>INDEX on mindex TO gggg
>SELECT 5
>USE table8
>INDEX on mindex TO o
>SELECT 6
>USE table9
>INDEX on mindex TO oo
>
>SELECT 1
>SET RELATION TO mindex INTO table5 additive
>SET RELATION TO mindex INTO table6 additive
>SET RELATION TO mindex INTO table7 additive
>SET RELATION TO mindex INTO table9 additive
>SET RELATION TO mindex INTO table10 additive
>
> && after 4 set relation's, foxpro says the following: Table10 is not found
Yeah, but I don't see where you opened it
Gregory
