OK, I created a new inclusion variable as suggested and it did not
work.
In the query below the error message I received was:
Ambiguous use of ! (inclusion variable)
Table :Ktables:Bioinfo.db
Field: Status
In the query below I put " _join1,_join5!" in the first field of the
first table.
And " _join1,_join5" in the first field of the last table:
I'm, sorry if this query isdifficult to read.

Craig

Query
ANSWER: :Ktables:sedationQIPeer2.db

:Ktables:Bioinfo.DB | Status | Year | Unique# |

:Ktables:Bioinfo.DB | HospitalNumber | FirstName | LastName |
Birthdate |
:Ktables:Sedationqimain.DB | Status | Year | Unique# | DateField |
:Ktables:Sedationqimain.DB | #forToday | Flag |
:Ktables:SedationQIsupplimental.DB | Status | Year | Unique# |
#ForToday |

:Ktables:SedationQIsupplimental.DB | MajorAdverseOutcome | SedationDOC
:Ktables:SedationQIsupplimental.DB | SedationDocAlsoProcDoc |
ASAStatus |

:Ktables:SedationQIsupplimental.DB | ASAeStatus |
:Ktables:SedationQIProblems.db | Status | Year | Unique# | #ForToday

:Ktables:Sedationqisub3.DB | Status | Year | Unique# |
#ForToday | Memo |

EndQuery

1. "join5!" in the first table should be "_join5!".

2. Try with only "_join5" in the Status field in the end table.

3. Depending on the result you want, you might have to put that "!"
symbol on ALL the common join fields between the first and end tables,
(and use unique names on each pairing, as you did for _join5).

- Mike


jonathan wrote: