query too Complex

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I have some pretty large tables, about 2.000.000 records, creating a simple
view which joins the tables gives an SQL query too complex...
When I zap the table it works as expected. When I remove some fields from
the select it sometimes works
And... when I compile it in VFP7 it works without any problem.

Anyone?

Gerben Kessen.





.

Relevant Pages

  • Re: Is there an SQL query for table schema ...
    ... > Is there an SQL query that will return a list of all indexes on a ... > In addition will it list the fields involved if it is a compound index? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: query too Complex
    ... I have some pretty large tables, about 2.000.000 records, creating a simple view which joins the tables gives an SQL query too complex... ... When I zap the table it works as expected. ... Our MVPs and MCPs make the Fox run.... ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Mikey has trouble writing his own lies.
    ... >>> How about 20 million consumers. ... > ZAP!!! ... hardly necessary anymore since most stuff is flat and sonically neutral. ... Prev by Date: ...
    (rec.audio.opinion)
  • 1-in-N Selection in SQL
    ... a dataset of several thousand using an SQL query? ... Neil ... Alternative Network Directory ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: select distinctrow
    ... >I am trying to make a form, where I have 4 lookup boxes. ... >it makes a sql query and every time I go to make another it overwrites the ... I have no idea what you mean by "preceded by the letters a b c.." ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)