Ambiguous outer joins

R

Renwick

I had a form that was working fine but I had included the
wrong table, when I corrected the error neither the quiery
that the form runs off or the for will run because I
have 'ambiguous outer joins' and the SQRL code needs to
know which join to enforse first. I don't know which join
I have is ambiguous or how to create a queiry that will
tell it which is first, or then, how to include that
queiry in the SQRL code for this one. I'm stuck, please
help if you can.
Here is the SQRL code for the Queiry as it stands

SELECT [Basic Data].[Participant Name], [Basic Data].[ID
Number], [Basic Data].School, [Basic Data].Male, [Basic
Data].[Year 5/6], [Pre Obs Teacher Led].ID, [Pre Obs
Teacher Led].[1A Attention: Group], [Pre Obs Teacher Led].
[1 B Disengaged], [Pre Obs Teacher Led].[4A Appropriate
group participation], [Pre Obs Teacher Led].[4B withdraws
from group], [Pre Obs Teacher Led].[5A Co-operative], [Pre
Obs Teacher Led].[5B Uncooperative], [Pre Obs Teacher Led].
[5A Uses environment appropriately], [Pre Obs Teacher
Led].[5B Destructive use of materials], [Pre Obs Teacher
Led].[3A Moves appropriately], [Pre Obs Teacher Led].[3B
Inappropriate movement], [Pre Obs Teacher Led].[2A Eye
contact- makes], [Pre Obs Teacher Led].[2B Eye contact-
avoids], [Pre Obs Teacher Led].[1A Starts tasks
willingly], [Pre Obs Teacher Led].[1B Delays and
procrastinates], [Pre Obs Teacher Led].[1A Completes tasks
appropriatly], [Pre Obs Teacher Led].[1B Leaves task
unfinished], [Pre Obs Teacher Led].[2A Accepts praise],
[Pre Obs Teacher Led].[2B Responds negatively to praise],
[Pre Obs Teacher Led].[2A Asks for help], [Pre Obs Teacher
Led].[2B Help- stuggles without asking], [Pre Obs Teacher
Led].[3A Obeys instruction], [Pre Obs Teacher Led].[3B
Ignores instruction], [Pre Obs Teacher Led].[3A takes
turn], [Pre Obs Teacher Led].[3B Demands], [Pre Obs
Teacher Led].[4A Communicates freely], [Pre Obs Teacher
Led].[4B No communication], [Pre Obs Teacher Led].[2A
Expresses appropriate feelings], [Pre Obs Teacher Led].[2B
No empathy-], [Pre Obs Teacher Led].[2A Appropriately
assertive], [Pre Obs Teacher Led].[2B Is bullied], [Pre
Obs Teacher Led].[4A Touches appropriately], [Pre Obs
Teacher Led].[4B Inappropriate touch:], [Pre Obs Teacher
Led].[4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[4B Bullies], [Pre Obs Teacher Led].[3A
Accepts dissapointment], [Pre Obs Teacher Led].[3B
Distressed when thwarted], [Pre Obs Teacher Led].[A1A
Attention: Group], [Pre Obs Teacher Led].[A1 B
Disengaged], [Pre Obs Teacher Led].[A4A Appropriate group
participation], [Pre Obs Teacher Led].[A4B Disruptive],
[Pre Obs Teacher Led].[A5A Co-operative], [Pre Obs Teacher
Led].[A5B Uncooperative], [Pre Obs Teacher Led].[A5A Uses
environment appropriately], [Pre Obs Teacher Led].[A5B
Destructive use of materials], [Pre Obs Teacher Led].[A3A
Moves appropriately], [Pre Obs Teacher Led].[A3B
Inappropriate movement], [Pre Obs Teacher Led].[A2A Eye
contact-], [Pre Obs Teacher Led].[A2B Eye contact-], [Pre
Obs Teacher Led].[A1A Starts tasks willingly], [Pre Obs
Teacher Led].[A1B Delays and procrastinates], [Pre Obs
Teacher Led].[A1A Completes tasks appropriatly], [Pre Obs
Teacher Led].[A1B Leaves task unfinished], [Pre Obs
Teacher Led].[A2A Accepts praise], [Pre Obs Teacher Led].
[A2B Responds negatively to praise], [Pre Obs Teacher Led].
[A2A Asks for help], [Pre Obs Teacher Led].[A2B Help-
stuggles without asking], [Pre Obs Teacher Led].[A3A Obeys
instruction], [Pre Obs Teacher Led].[A3B Ignores
instruction], [Pre Obs Teacher Led].[A3A takes turn], [Pre
Obs Teacher Led].[A3B Demands], [Pre Obs Teacher Led].[A4A
Communicates freely], [Pre Obs Teacher Led].[A4B No
communication], [Pre Obs Teacher Led].[A2A Expresses
appropriate feelings], [Pre Obs Teacher Led].[A2B No
empathy], [Pre Obs Teacher Led].[A2A Appropriately
assertive], [Pre Obs Teacher Led].[A2B Is bullied], [Pre
Obs Teacher Led].[A4A Touches appropriately], [Pre Obs
Teacher Led].[A4B Inappropriate touch:], [Pre Obs Teacher
Led].[A4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[A4B Bullies], [Pre Obs Teacher Led].[A3A
Accepts dissapointment], [Pre Obs Teacher Led].[A3B
Distressed when thwarted], [Pre Obs Individual].ID, [Pre
Obs Individual].[1A Attention: Group], [Pre Obs
Individual].[1 B Disengaged], [Pre Obs Individual].[4A
Appropriate group participation], [Pre Obs Individual].
[4B withdraws from group], [Pre Obs Individual].[5A Co-
operative], [Pre Obs Individual].[5B Uncooperative-], [Pre
Obs Individual].[5A Uses materials appropriately], [Pre
Obs Individual].[5B Destructive use of materials], [Pre
Obs Individual].[3A Moves appropriately], [Pre Obs
Individual].[3B Inappropriate movement], [Pre Obs
Individual].[2A Eye contact- make], [Pre Obs Individual].
[2B Eye contact- avoids], [Pre Obs Individual].[1A Starts
tasks willingly], [Pre Obs Individual].[1B Delays and
procrastinates], [Pre Obs Individual].[1A Completes tasks
appropriatly], [Pre Obs Individual].[1B Leaves task
unfinished], [Pre Obs Individual].[2A Accepts praise],
[Pre Obs Individual].[2B Responds negatively to praise],
[Pre Obs Individual].[2A Asks for help], [Pre Obs
Individual].[2B Help- stuggles without asking], [Pre Obs
Individual].[3A Obeys instruction], [Pre Obs Individual].
[3B Ignores instruction], [Pre Obs Individual].[3A takes
turn], [Pre Obs Individual].[3B Demands], [Pre Obs
Individual].[4A Communicates freely], [Pre Obs Individual].
[4B No communication], [Pre Obs Individual].[2A Expresses
appropriate feelings], [Pre Obs Individual].[2B No empathy-
feelings inappropriate], [Pre Obs Individual].[2A
Appropriately assertive], [Pre Obs Individual].[2B Is
bullied/ picked on], [Pre Obs Individual].[4A Touches
appropriately], [Pre Obs Individual].[4B Inappropriate
touch:], [Pre Obs Individual].[4A Positive and appropiate
interaction], [Pre Obs Individual].[4B Bullies/
Intimidates], [Pre Obs Individual].[3A Accepts
dissapointment], [Pre Obs Individual].[3B Angry when
thwarted], [Pre Obs Individual].[A1A Attention: Group-
Focused], [Pre Obs Individual].[A1 B Disengaged], [Pre Obs
Individual].[A4A Appropriate group participation], [Pre
Obs Individual].[A4B withdraws from group], [Pre Obs
Individual].[A5A Co-operative], [Pre Obs Individual].[A5B
Uncooperative], [Pre Obs Individual].[A5A Uses materialst
appropriately], [Pre Obs Individual].[A5B Destructive/
Inappropriate use of materials], [Pre Obs Individual].[A3A
Moves/ sits appropriately], [Pre Obs Individual].[A3B
Inappropriate movement/ ativity/ position], [Pre Obs
Individual].[A2A Eye contact- makes/ responds to], [Pre
Obs Individual].[A2B Eye contact- avoids], [Pre Obs
Individual].[A1A Starts tasks willingly], [Pre Obs
Individual].[A1B Delays and procrastinates], [Pre Obs
Individual].[A1A Completes tasks appropriatly], [Pre Obs
Individual].[A1B Leaves task unfinished], [Pre Obs
Individual].[A2A Accepts praise], [Pre Obs Individual].
[A2B Responds negatively to praise], [Pre Obs Individual].
[A2A Asks for help], [Pre Obs Individual].[A2B Help-
stuggles without asking], [Pre Obs Individual].[A3A Obeys
instruction], [Pre Obs Individual].[A3B Ignores
instruction], [Pre Obs Individual].[A3A takes turn], [Pre
Obs Individual].[A3B Demands], [Pre Obs Individual].[A4A
Communicates freely], [Pre Obs Individual].[A4B No
communication], [Pre Obs Individual].[A2A Expresses
appropriate feelings], [Pre Obs Individual].[A2B No
empathy- feelings inappropriate], [Pre Obs Individual].
[A2A Appropriately assertive], [Pre Obs Individual].[A2B
Is bullied], [Pre Obs Individual].[A4A Touches
appropriately], [Pre Obs Individual].[A4B Inappropriate
touch:], [Pre Obs Individual].[A4A Positive and appropiate
interaction], [Pre Obs Individual].[A4B Bullies], [Pre Obs
Individual].[A3A Accepts dissapointment], [Pre Obs
Individual].[A3BDistressed when thwarted], [Pre Obs Group
Work].ID, [Pre Obs Group Work].[1A Attention:], [Pre Obs
Group Work].[1 B Disengaged], [Pre Obs Group Work].[4A
Appropriate group], [Pre Obs Group Work].[4B Disruptive/
group], [Pre Obs Group Work].[5A Co-operative-], [Pre Obs
Group Work].[5B Uncooperative-], [Pre Obs Group Work].[5A
Uses materials appropriately], [Pre Obs Group Work].[5B
Destructive use of materials], [Pre Obs Group Work].[3A
Moves appropriately], [Pre Obs Group Work].[3B
Inappropriate movement], [Pre Obs Group Work].[2A Eye
contact- makes], [Pre Obs Group Work].[2B Eye contact-
avoids], [Pre Obs Group Work].[1A Starts tasks willingly],
[Pre Obs Group Work].[1B Delays and procrastinates], [Pre
Obs Group Work].[1A Completes tasks appropriatly], [Pre
Obs Group Work].[1B Leaves task unfinished], [Pre Obs
Group Work].[2A Accepts praise], [Pre Obs Group Work].[2B
Responds negatively to praise], [Pre Obs Group Work].[2A
Asks for help], [Pre Obs Group Work].[2B Help- stuggles
without asking], [Pre Obs Group Work].[3A Obeys
instruction], [Pre Obs Group Work].[3B Ignores
instruction], [Pre Obs Group Work].[3A takes turn], [Pre
Obs Group Work].[3B Demands], [Pre Obs Group Work].[4A
Communicates freely], [Pre Obs Group Work].[4B No
communication], [Pre Obs Group Work].[2A Expresses
appropriate feelings], [Pre Obs Group Work].[2B No empathy-
], [Pre Obs Group Work].[2A Appropriately assertive], [Pre
Obs Group Work].[2B Is bullied], [Pre Obs Group Work].[4A
Touches appropriately], [Pre Obs Group Work].[4B
Inappropriate touch:], [Pre Obs Group Work].[4A Positive
and appropiate interaction], [Pre Obs Group Work].[4B
Bullies/ Intimidates], [Pre Obs Group Work].[3A Accepts
dissapointment], [Pre Obs Group Work].[3B Angry when
thwarted], [Pre Obs Group Work].[A1A Attention: Group-
Focused], [Pre Obs Group Work].[A1 B Disengaged], [Pre Obs
Group Work].[A4A Appropriate group participation], [Pre
Obs Group Work].[A4B withdraws from group], [Pre Obs Group
Work].[A5A Co-operative], [Pre Obs Group Work].[A5B
Uncooperative-], [Pre Obs Group Work].[A5A Uses
environment appropriately], [Pre Obs Group Work].[A5B
Destructive use of materials], [Pre Obs Group Work].[A3A
Moves appropriately], [Pre Obs Group Work].[A3B
Inappropriate movement], [Pre Obs Group Work].[A2A Eye
contact- makes], [Pre Obs Group Work].[A2B Eye contact-
avoids], [Pre Obs Group Work].[A1A Starts tasks
willingly], [Pre Obs Group Work].[A1B Delays and
procrastinates], [Pre Obs Group Work].[A1A Completes tasks
appropriatly], [Pre Obs Group Work].[A1B Leaves task
unfinished], [Pre Obs Group Work].[A2A Accepts praise],
[Pre Obs Group Work].[A2B Responds negatively to praise],
[Pre Obs Group Work].[A2A Asks for help], [Pre Obs Group
Work].[A2Bstuggles without asking], [Pre Obs Group Work].
[A3A Obeys instruction], [Pre Obs Group Work].[A3B
disobeys instruction], [Pre Obs Group Work].[A3A takes
turn], [Pre Obs Group Work].[A3B Demands], [Pre Obs Group
Work].[A4A Communicates freely], [Pre Obs Group Work].[A4B
No communication], [Pre Obs Group Work].[A2A Expresses
appropriate feelings], [Pre Obs Group Work].[A2B No
empathy- feelings inappropriate], [Pre Obs Group Work].
[A2A Appropriately assertive], [Pre Obs Group Work].[A2B
Is bullied], [Pre Obs Group Work].[A4A Touches
appropriately], [Pre Obs Group Work].[A4B Inappropriate
touch:], [Pre Obs Group Work].[A4A Positive and appropiate
interaction], [Pre Obs Group Work].[A4B Bullies/
Intimidates], [Pre Obs Group Work].[A3A Accepts
dissapointmen], [Pre Obs Group Work].[A3B Angry/when
thwarted]
FROM ([Basic Data] LEFT JOIN ([Pre Obs Group Work] INNER
JOIN [Pre Obs Teacher Led] ON [Pre Obs Group Work].ID =
[Pre Obs Teacher Led].ID) ON ([Basic Data].[ID Number] =
[Pre Obs Teacher Led].ID) AND ([Basic Data].[ID Number] =
[Pre Obs Group Work].ID)) LEFT JOIN [Pre Obs Individual]
ON [Basic Data].[ID Number] = [Pre Obs Individual].ID;
 
E

Ed Robichaud

Well, not to appear pedantic but it's "SQL" and "query". I also doubt that
few people will bother to read, let alone critique your query design, as
most queries that return 25+ fields are symptomatic of bad data design, and
no quick fix will suffice.

That said, make a copy of your original query, and troubleshoot by changing
each of the joins (one at a time) to find one of the two that are in
conflict. You can usually create a "pre-query" containing that join, then
use the result in your final query.

BTW, shorter field names (without spaces) will come in handy. You can use
the Caption property to display a fuller name/description in your forms &
reports.
-Ed

Renwick said:
I had a form that was working fine but I had included the
wrong table, when I corrected the error neither the quiery
that the form runs off or the for will run because I
have 'ambiguous outer joins' and the SQRL code needs to
know which join to enforse first. I don't know which join
I have is ambiguous or how to create a queiry that will
tell it which is first, or then, how to include that
queiry in the SQRL code for this one. I'm stuck, please
help if you can.
Here is the SQRL code for the Queiry as it stands

SELECT [Basic Data].[Participant Name], [Basic Data].[ID
Number], [Basic Data].School, [Basic Data].Male, [Basic
Data].[Year 5/6], [Pre Obs Teacher Led].ID, [Pre Obs
Teacher Led].[1A Attention: Group], [Pre Obs Teacher Led].
[1 B Disengaged], [Pre Obs Teacher Led].[4A Appropriate
group participation], [Pre Obs Teacher Led].[4B withdraws
from group], [Pre Obs Teacher Led].[5A Co-operative], [Pre
Obs Teacher Led].[5B Uncooperative], [Pre Obs Teacher Led].
[5A Uses environment appropriately], [Pre Obs Teacher
Led].[5B Destructive use of materials], [Pre Obs Teacher
Led].[3A Moves appropriately], [Pre Obs Teacher Led].[3B
Inappropriate movement], [Pre Obs Teacher Led].[2A Eye
contact- makes], [Pre Obs Teacher Led].[2B Eye contact-
avoids], [Pre Obs Teacher Led].[1A Starts tasks
willingly], [Pre Obs Teacher Led].[1B Delays and
procrastinates], [Pre Obs Teacher Led].[1A Completes tasks
appropriatly], [Pre Obs Teacher Led].[1B Leaves task
unfinished], [Pre Obs Teacher Led].[2A Accepts praise],
[Pre Obs Teacher Led].[2B Responds negatively to praise],
[Pre Obs Teacher Led].[2A Asks for help], [Pre Obs Teacher
Led].[2B Help- stuggles without asking], [Pre Obs Teacher
Led].[3A Obeys instruction], [Pre Obs Teacher Led].[3B
Ignores instruction], [Pre Obs Teacher Led].[3A takes
turn], [Pre Obs Teacher Led].[3B Demands], [Pre Obs
Teacher Led].[4A Communicates freely], [Pre Obs Teacher
Led].[4B No communication], [Pre Obs Teacher Led].[2A
Expresses appropriate feelings], [Pre Obs Teacher Led].[2B
No empathy-], [Pre Obs Teacher Led].[2A Appropriately
assertive], [Pre Obs Teacher Led].[2B Is bullied], [Pre
Obs Teacher Led].[4A Touches appropriately], [Pre Obs
Teacher Led].[4B Inappropriate touch:], [Pre Obs Teacher
Led].[4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[4B Bullies], [Pre Obs Teacher Led].[3A
Accepts dissapointment], [Pre Obs Teacher Led].[3B
Distressed when thwarted], [Pre Obs Teacher Led].[A1A
Attention: Group], [Pre Obs Teacher Led].[A1 B
Disengaged], [Pre Obs Teacher Led].[A4A Appropriate group
participation], [Pre Obs Teacher Led].[A4B Disruptive],
[Pre Obs Teacher Led].[A5A Co-operative], [Pre Obs Teacher
Led].[A5B Uncooperative], [Pre Obs Teacher Led].[A5A Uses
environment appropriately], [Pre Obs Teacher Led].[A5B
Destructive use of materials], [Pre Obs Teacher Led].[A3A
Moves appropriately], [Pre Obs Teacher Led].[A3B
Inappropriate movement], [Pre Obs Teacher Led].[A2A Eye
contact-], [Pre Obs Teacher Led].[A2B Eye contact-], [Pre
Obs Teacher Led].[A1A Starts tasks willingly], [Pre Obs
Teacher Led].[A1B Delays and procrastinates], [Pre Obs
Teacher Led].[A1A Completes tasks appropriatly], [Pre Obs
Teacher Led].[A1B Leaves task unfinished], [Pre Obs
Teacher Led].[A2A Accepts praise], [Pre Obs Teacher Led].
[A2B Responds negatively to praise], [Pre Obs Teacher Led].
[A2A Asks for help], [Pre Obs Teacher Led].[A2B Help-
stuggles without asking], [Pre Obs Teacher Led].[A3A Obeys
instruction], [Pre Obs Teacher Led].[A3B Ignores
instruction], [Pre Obs Teacher Led].[A3A takes turn], [Pre
Obs Teacher Led].[A3B Demands], [Pre Obs Teacher Led].[A4A
Communicates freely], [Pre Obs Teacher Led].[A4B No
communication], [Pre Obs Teacher Led].[A2A Expresses
appropriate feelings], [Pre Obs Teacher Led].[A2B No
empathy], [Pre Obs Teacher Led].[A2A Appropriately
assertive], [Pre Obs Teacher Led].[A2B Is bullied], [Pre
Obs Teacher Led].[A4A Touches appropriately], [Pre Obs
Teacher Led].[A4B Inappropriate touch:], [Pre Obs Teacher
Led].[A4A Positive and appropiate interaction], [Pre Obs
Teacher Led].[A4B Bullies], [Pre Obs Teacher Led].[A3A
Accepts dissapointment], [Pre Obs Teacher Led].[A3B
Distressed when thwarted], [Pre Obs Individual].ID, [Pre
Obs Individual].[1A Attention: Group], [Pre Obs
Individual].[1 B Disengaged], [Pre Obs Individual].[4A
Appropriate group participation], [Pre Obs Individual].
[4B withdraws from group], [Pre Obs Individual].[5A Co-
operative], [Pre Obs Individual].[5B Uncooperative-], [Pre
Obs Individual].[5A Uses materials appropriately], [Pre
Obs Individual].[5B Destructive use of materials], [Pre
Obs Individual].[3A Moves appropriately], [Pre Obs
Individual].[3B Inappropriate movement], [Pre Obs
Individual].[2A Eye contact- make], [Pre Obs Individual].
[2B Eye contact- avoids], [Pre Obs Individual].[1A Starts
tasks willingly], [Pre Obs Individual].[1B Delays and
procrastinates], [Pre Obs Individual].[1A Completes tasks
appropriatly], [Pre Obs Individual].[1B Leaves task
unfinished], [Pre Obs Individual].[2A Accepts praise],
[Pre Obs Individual].[2B Responds negatively to praise],
[Pre Obs Individual].[2A Asks for help], [Pre Obs
Individual].[2B Help- stuggles without asking], [Pre Obs
Individual].[3A Obeys instruction], [Pre Obs Individual].
[3B Ignores instruction], [Pre Obs Individual].[3A takes
turn], [Pre Obs Individual].[3B Demands], [Pre Obs
Individual].[4A Communicates freely], [Pre Obs Individual].
[4B No communication], [Pre Obs Individual].[2A Expresses
appropriate feelings], [Pre Obs Individual].[2B No empathy-
feelings inappropriate], [Pre Obs Individual].[2A
Appropriately assertive], [Pre Obs Individual].[2B Is
bullied/ picked on], [Pre Obs Individual].[4A Touches
appropriately], [Pre Obs Individual].[4B Inappropriate
touch:], [Pre Obs Individual].[4A Positive and appropiate
interaction], [Pre Obs Individual].[4B Bullies/
Intimidates], [Pre Obs Individual].[3A Accepts
dissapointment], [Pre Obs Individual].[3B Angry when
thwarted], [Pre Obs Individual].[A1A Attention: Group-
Focused], [Pre Obs Individual].[A1 B Disengaged], [Pre Obs
Individual].[A4A Appropriate group participation], [Pre
Obs Individual].[A4B withdraws from group], [Pre Obs
Individual].[A5A Co-operative], [Pre Obs Individual].[A5B
Uncooperative], [Pre Obs Individual].[A5A Uses materialst
appropriately], [Pre Obs Individual].[A5B Destructive/
Inappropriate use of materials], [Pre Obs Individual].[A3A
Moves/ sits appropriately], [Pre Obs Individual].[A3B
Inappropriate movement/ ativity/ position], [Pre Obs
Individual].[A2A Eye contact- makes/ responds to], [Pre
Obs Individual].[A2B Eye contact- avoids], [Pre Obs
Individual].[A1A Starts tasks willingly], [Pre Obs
Individual].[A1B Delays and procrastinates], [Pre Obs
Individual].[A1A Completes tasks appropriatly], [Pre Obs
Individual].[A1B Leaves task unfinished], [Pre Obs
Individual].[A2A Accepts praise], [Pre Obs Individual].
[A2B Responds negatively to praise], [Pre Obs Individual].
[A2A Asks for help], [Pre Obs Individual].[A2B Help-
stuggles without asking], [Pre Obs Individual].[A3A Obeys
instruction], [Pre Obs Individual].[A3B Ignores
instruction], [Pre Obs Individual].[A3A takes turn], [Pre
Obs Individual].[A3B Demands], [Pre Obs Individual].[A4A
Communicates freely], [Pre Obs Individual].[A4B No
communication], [Pre Obs Individual].[A2A Expresses
appropriate feelings], [Pre Obs Individual].[A2B No
empathy- feelings inappropriate], [Pre Obs Individual].
[A2A Appropriately assertive], [Pre Obs Individual].[A2B
Is bullied], [Pre Obs Individual].[A4A Touches
appropriately], [Pre Obs Individual].[A4B Inappropriate
touch:], [Pre Obs Individual].[A4A Positive and appropiate
interaction], [Pre Obs Individual].[A4B Bullies], [Pre Obs
Individual].[A3A Accepts dissapointment], [Pre Obs
Individual].[A3BDistressed when thwarted], [Pre Obs Group
Work].ID, [Pre Obs Group Work].[1A Attention:], [Pre Obs
Group Work].[1 B Disengaged], [Pre Obs Group Work].[4A
Appropriate group], [Pre Obs Group Work].[4B Disruptive/
group], [Pre Obs Group Work].[5A Co-operative-], [Pre Obs
Group Work].[5B Uncooperative-], [Pre Obs Group Work].[5A
Uses materials appropriately], [Pre Obs Group Work].[5B
Destructive use of materials], [Pre Obs Group Work].[3A
Moves appropriately], [Pre Obs Group Work].[3B
Inappropriate movement], [Pre Obs Group Work].[2A Eye
contact- makes], [Pre Obs Group Work].[2B Eye contact-
avoids], [Pre Obs Group Work].[1A Starts tasks willingly],
[Pre Obs Group Work].[1B Delays and procrastinates], [Pre
Obs Group Work].[1A Completes tasks appropriatly], [Pre
Obs Group Work].[1B Leaves task unfinished], [Pre Obs
Group Work].[2A Accepts praise], [Pre Obs Group Work].[2B
Responds negatively to praise], [Pre Obs Group Work].[2A
Asks for help], [Pre Obs Group Work].[2B Help- stuggles
without asking], [Pre Obs Group Work].[3A Obeys
instruction], [Pre Obs Group Work].[3B Ignores
instruction], [Pre Obs Group Work].[3A takes turn], [Pre
Obs Group Work].[3B Demands], [Pre Obs Group Work].[4A
Communicates freely], [Pre Obs Group Work].[4B No
communication], [Pre Obs Group Work].[2A Expresses
appropriate feelings], [Pre Obs Group Work].[2B No empathy-
], [Pre Obs Group Work].[2A Appropriately assertive], [Pre
Obs Group Work].[2B Is bullied], [Pre Obs Group Work].[4A
Touches appropriately], [Pre Obs Group Work].[4B
Inappropriate touch:], [Pre Obs Group Work].[4A Positive
and appropiate interaction], [Pre Obs Group Work].[4B
Bullies/ Intimidates], [Pre Obs Group Work].[3A Accepts
dissapointment], [Pre Obs Group Work].[3B Angry when
thwarted], [Pre Obs Group Work].[A1A Attention: Group-
Focused], [Pre Obs Group Work].[A1 B Disengaged], [Pre Obs
Group Work].[A4A Appropriate group participation], [Pre
Obs Group Work].[A4B withdraws from group], [Pre Obs Group
Work].[A5A Co-operative], [Pre Obs Group Work].[A5B
Uncooperative-], [Pre Obs Group Work].[A5A Uses
environment appropriately], [Pre Obs Group Work].[A5B
Destructive use of materials], [Pre Obs Group Work].[A3A
Moves appropriately], [Pre Obs Group Work].[A3B
Inappropriate movement], [Pre Obs Group Work].[A2A Eye
contact- makes], [Pre Obs Group Work].[A2B Eye contact-
avoids], [Pre Obs Group Work].[A1A Starts tasks
willingly], [Pre Obs Group Work].[A1B Delays and
procrastinates], [Pre Obs Group Work].[A1A Completes tasks
appropriatly], [Pre Obs Group Work].[A1B Leaves task
unfinished], [Pre Obs Group Work].[A2A Accepts praise],
[Pre Obs Group Work].[A2B Responds negatively to praise],
[Pre Obs Group Work].[A2A Asks for help], [Pre Obs Group
Work].[A2Bstuggles without asking], [Pre Obs Group Work].
[A3A Obeys instruction], [Pre Obs Group Work].[A3B
disobeys instruction], [Pre Obs Group Work].[A3A takes
turn], [Pre Obs Group Work].[A3B Demands], [Pre Obs Group
Work].[A4A Communicates freely], [Pre Obs Group Work].[A4B
No communication], [Pre Obs Group Work].[A2A Expresses
appropriate feelings], [Pre Obs Group Work].[A2B No
empathy- feelings inappropriate], [Pre Obs Group Work].
[A2A Appropriately assertive], [Pre Obs Group Work].[A2B
Is bullied], [Pre Obs Group Work].[A4A Touches
appropriately], [Pre Obs Group Work].[A4B Inappropriate
touch:], [Pre Obs Group Work].[A4A Positive and appropiate
interaction], [Pre Obs Group Work].[A4B Bullies/
Intimidates], [Pre Obs Group Work].[A3A Accepts
dissapointmen], [Pre Obs Group Work].[A3B Angry/when
thwarted]
FROM ([Basic Data] LEFT JOIN ([Pre Obs Group Work] INNER
JOIN [Pre Obs Teacher Led] ON [Pre Obs Group Work].ID =
[Pre Obs Teacher Led].ID) ON ([Basic Data].[ID Number] =
[Pre Obs Teacher Led].ID) AND ([Basic Data].[ID Number] =
[Pre Obs Group Work].ID)) LEFT JOIN [Pre Obs Individual]
ON [Basic Data].[ID Number] = [Pre Obs Individual].ID;
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ambiguous outer joins 3
Automatic Cut & Paste - Possible? 1
Page numbering with Merged Document and IF statements 1
Lookup Formula 3
Paste special into a filtered work sheet 0
Conditional formatting 3
formulas for conditional formatting 5
Programming cells to read other cells 1

Top