Re: nasty SQL query, please advise...

unfortunately, I don't think I can do this in a single query. It turns
out there is no visitID -- I made an assumption. At any rate, I didn't
know you were allowed to refer to the outer table from inside a
subquery.

I don't have a lot of experience with the more complex queries. My SQL
reference book doesn't have anything about using an update and a join
in the same statement...

Also, the query can be simplified (and made faster) because I don't
need to join with the clients table -- the clientnumber is in the
coverage table!

I decided to write a little program that will iterate through the
visits table, and look up the client number for each record in the
visits table. It will be slower than a query, though, I think, and
this is a very large table... However, I won't need to do any joins,
and the index will be used, so maybe the speed is comparable.

Thanks anyway...

-Corinna

.

Relevant Pages

  • Re: Summarizing records in one table that match a different table
    ... the report. ... using "Language" as the example (i had to add a field to my Clients test ... i created a report based on the query with the joins ...
    (microsoft.public.access.reports)
  • Re: SP3 Inventory causing 100% CPU issues
    ... This new class added in SP3 collects auto run software information ... This class only collects auto run software information. ... can use wbemtest to find out which query caused the problem. ... at 100% cpu for hours causing the clients to be unusable since ...
    (microsoft.public.sms.admin)
  • RE: SMS 2003 Query Software Distribution Status
    ... noticed you had a query you didn't get working and started searching on ... Now that I see you wanted this for rerunning an advertisement I might as ... the advertisement only reruns on the failed clients. ... If you want to rerun on a single client, we can delete the job on an ...
    (microsoft.public.sms.admin)
  • Re: MySQL Connections buendeln
    ... Slow query log zeigt die ueblichen Queries wo halt viele dort drin stehen ... ich werd' das mal reduzieren um die Load lieber auf die Clients ...
    (de.comp.datenbanken.mysql)
  • Re: Caclulating Count of unique values
    ... Create a query into both tables. ... All clients, and any matching Orders. ... Drag ClientID from the Client table into the grid. ... In the Total row, accept Group By under this field. ...
    (microsoft.public.access.modulesdaovba)