Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT Query - Step 1 - Connecting Tables
DAT Query - Step 1 - Connecting Tables
DAT Query - Step 1 - Connecting Tables
A
DAT Query
allows you to pull data from multiple tables. The Connecting Tables mechanism allows you to connect (join) different tables in your
DAT Query
. To connect one of the tables in your
DAT Query
to a new table, navigate to
DAT Query - Step 1
(
DAT
> Queries > Query).
1. Click the [+] icon next to the table you are connecting to.
2. Choose whether you will connect “with” or “with or without”.
- If you choose “with”, the newly connected table must have data for the original table's record to show up.
- If you choose “with or without”, the original table's records will always show; however, the newly connected table might not have any data for a particular record - and those columns are empty.
Example
: Your initial table is students, and you choose to join to actions. For the actions, you are going to include
DAT Field Condition
s only for Enrolled actions in 2014/2015. If you choose “with”, only students who have such an action appear in the result set. If you choose “with or without”, then all students appear in the result set, but action fields are empty for students who do not have an Enrolled action for 2014/2015.
Note
: If you link to a table “with or without”, and additional tables connected to that table will also be linked as “with or without”.
Note
: Tables that are connected as “with or without” show as italicized.
Note
: It is entirely possible to add the same table multiple times. Suppose you want to see all your applicants for the 2014/2015 school year. You also want to see their inquiry action date, apply online date, and copied date. Many of your inquiry records for the year may or may not have apply online or copied dates. So, you connect Inquiry
Action
s to your inquiries three times: Once for action types of Inquiry for academic year 2014/2015; once for action types of Applicant; once for action types of Copied. Each of these links would be made with the “with or without” option.
See also
DAT Field Condition
DAT Query - Step 1
DAT Query
Action
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.