If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Ambiguous outer joins
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; |
#2
|
|||
|
|||
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" wrote in message ... 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; |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Joins in a Query | B Earl | New Users | 1 | January 10th, 2005 10:22 AM |
Outer Join more than two tables. Possible? | E. Froma | Running & Setting Up Queries | 1 | November 2nd, 2004 08:37 PM |
Outer Joins??? | esi | Running & Setting Up Queries | 1 | August 26th, 2004 02:23 PM |
Slow Outer Joins | CoMET | Running & Setting Up Queries | 2 | June 7th, 2004 02:01 PM |
Ambiguous outer joins | Stephen Glynn | New Users | 1 | May 28th, 2004 12:25 PM |