Example 1
It is possible to have duplicate names. For example, if you do not select StudentContactType as SC1, you only pick up the primary contacts and not Term and Alternate as well. Otherwise, you would be returning one line for every contact that a student has.
Query with duplicate records | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT ID, StudentContactMailName, StudentContactAddressComma, StudentContactType | ||||||||||||
Returns | ||||||||||||
|
Query with correction | ||||||||
|---|---|---|---|---|---|---|---|---|
SELECT ID, StudentContactMailName, StudentContactAddressComma, StudentContactType | ||||||||
| Returns | ||||||||
|
...
- YearLevel field to the query
key word DISTINCT.
| Query with correction | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| SELECT DISTINCT StudentContactMailName, StudentContactAddressComma, YearLevel FROM vStudentContactAddress WHERE StudentContactNormalMailFlag = 1 AND CurrentSemesterOnlyFlag = 1 | |||||||||
| Returns | |||||||||
|