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
My database for was not recording in the right place,
realised it was not bound to the right sourse so fixed it, not it won't run because my SQRL has ambiguoise outer jons, it needs to know which to perform first. I don't know which joins it is talking about and also how to create a new quiery that will tell it or how to include that in te SQRL in the quiery that the form runns off. Here is the SQRL for the qurie 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
|
|||
|
|||
From the long list of what appears to be "repeating fields" in your SQL
statement, I wonder if your data structure isn't causing you (and Access) some issues. Queries are only as effective as the underlying data structure they rely on. Perhaps you could provide a bit more description of your data structure... -- More info, please ... Jeff Boyce Access MVP "renwick" wrote in message ... My database for was not recording in the right place, realised it was not bound to the right sourse so fixed it, not it won't run because my SQRL has ambiguoise outer jons, it needs to know which to perform first. I don't know which joins it is talking about and also how to create a new quiery that will tell it or how to include that in te SQRL in the quiery that the form runns off. Here is the SQRL for the qurie 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; |
#3
|
|||
|
|||
The database is to collect complex data on observations of
school children. Each catagory is observed for 10min the way that the raw data is provided for data entry is in sheets of 5 min each, so we obsereve for exapmle teacher led, how well they pay attention for 5 min and then move onto another sheet I have to keep the entry system under the same rules as the paper versions. each behaviour is either present or not, we then observe attention for when they are working individually for 10 min and then in a group of their peers for 10 min. That is why there seem to be repeating catagories. so 1A is sheet one and A1A is sheet two, there will be the same name present for the three types of classroom activity. all that I want o do is display it in a form but the form runs off this quiery becaue there was too much data for all three data types and both sheets to be on one table, so I have had to split it up. THey data is meant to be locked together using the ID number which the computer genertates. This is to ensure data protection so that only we know that childs name. THe ID number joins seem to behat is causeing the problems as each type of classroom behaviour has an ID number present on the Quiery in order to ensure we see the teacher led, group and individual work for the same ID number on each record. I know that its complicted, I couldn't make it work any other way, believe me, I tried! Renwick -----Original Message----- From the long list of what appears to be "repeating fields" in your SQL statement, I wonder if your data structure isn't causing you (and Access) some issues. Queries are only as effective as the underlying data structure they rely on. Perhaps you could provide a bit more description of your data structure... -- More info, please ... Jeff Boyce Access MVP "renwick" wrote in message ... My database for was not recording in the right place, realised it was not bound to the right sourse so fixed it, not it won't run because my SQRL has ambiguoise outer jons, it needs to know which to perform first. I don't know which joins it is talking about and also how to create a new quiery that will tell it or how to include that in te SQRL in the quiery that the form runns off. Here is the SQRL for the qurie 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; . |
#4
|
|||
|
|||
Occasionally, a situation arises in a multiple table query in which you need
to use an Outer-Join. Oddly, sometimes Access allows you to do it, and sometimes it gives you the very unhelpful "Ambiguous Outer Join" error. Why? Well, to understand this and how to correct it, let's first determine what an Ambiguous Outer Join is. When Access processes a multiple table query, it needs to determine the order in which joins should be made. Should it join Table1 to Table2 first and then join Table3? Or should it do it in some other order. This is part of the Rushmore technology of the Jet engine. It tries to determine the most efficient way to process the query. In the case of standard Equi-Joins, the query result will not vary based on the order that they are joined. However, this is not the case with Outer-Joins. There are times, when using an Outer-Join, that the result of the query will be different depending on the order in which joins are created. Access cannot now determine the order to join the tables. This is an Ambiguous Outer Join. Another way to explain it, is in terms of what you see in the QBE grid. A table which participates in an Outer join and the arrow is pointing *towards* it cannot participate in either an Inner Join, or another Outer Join where the arrow points towards it. Graphically: These are illegal: 1) Table1 ----- Table2 ----- Table3 2) Table1 ----- Table2 ---- Table3 This is legal: 3) Table1 ----- Table2 ---- Table3 In order to solve this, you are going to have to split the query into a stacked query, just like Access suggests you should in the error message. So you create a query joining the first two tables and, in a second query, join the first query to the third table. Thus: 1) Query1: Table1 ----- Table2 2) Query2: Query1 ------ Table3 -- --Roger Carlson Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "renwick" wrote in message ... My database for was not recording in the right place, realised it was not bound to the right sourse so fixed it, not it won't run because my SQRL has ambiguoise outer jons, it needs to know which to perform first. I don't know which joins it is talking about and also how to create a new quiery that will tell it or how to include that in te SQRL in the quiery that the form runns off. Here is the SQRL for the qurie 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 |
Ambiguous outer joins | Renwick | New Users | 1 | February 22nd, 2005 02:08 PM |
Joins in a Query | B Earl | New Users | 1 | January 10th, 2005 09:22 AM |
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 |