Recent content by RodCramp

  1. R

    Using AND in INNER JOIN

    Great, LOG_ID is duplicated, but never with the same SERVICES_ID in the SERVICELINK Table, don't see any issues as yet requiring use of DISTINCT. Thanks again.
  2. R

    Using AND in INNER JOIN

    Banana, You're oddly bent, yellow with brown spots & squishy on the inside... But a genius! Results looking good & are FAST. My only problem now is comprehending your mushy work… and trying to include other WHERE parameters allowed within the larger sort form… but that’s for another day...
  3. R

    Using AND in INNER JOIN

    Thanks Banana, this won't result in the requirement to filter the records in the main (LOG) table. The SERVICELINKS table lists LOG_ID's & SERVICES_ID's. - The desire is to have a result from LOG.* table where any specific LOG_ID in table SERVICELINKS has 2 SERVICE_ID's satisfying the search...
  4. R

    Using AND in INNER JOIN

    Thanks guys, SimonB1978 the result is exactly what I'm after. Only issue now is that with > 80k records in SERVICELINKS it takes about 2 minutes to run, and I haven't even tried running it with the back-end on a network drive as yet. Will try cloning recordset & comparing the 2(3) sets, am...
  5. R

    Using AND in INNER JOIN

    I have 3 x tables LOG, SERVICES, SERVICELINKS. LOG is used to write new records to. SERVICES has a list of items that a LOG record may/may not have any number of references to. Referencing is done by using table SERVICELINKS. SERVICELINKS includes LOG_ID & SERVICES_ID. I'm attempting to create...
See more
Back
Top Bottom