Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Records missing from SQL query
Message
From
01/05/2004 10:55:40
 
 
To
01/05/2004 09:44:43
Steven Kleypas
Tarrant County College District
Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00899906
Message ID:
00900032
Views:
23
This message has been marked as a message which has helped to the initial question of the thread.
precise
* SOL 2
* 1 STUDENT
iStudentId = NNNN
* ALL STUDENTS
iStudentId = NULL
WHERE courses.iid = m.iCourseId AND (m.iStudentId IS NULL OR students.iid = m.iStudentId)
flexible
* SOL 1
* 1 STUDENT
wExp = "courses.iid = m.iCourseId AND students.iid = m.iStudentId"
* ALL STUDENTS
wExp = "courses.iid = m.iCourseId"
WHERE &wExp
illogic
* SOL 3
* 1 STUDENT
sStudentId = STR(NNNN)
* ALL STUDENTS
sStudentId = '%'
WHERE courses.iid = m.iCourseId AND STR(students.iid) LIKE m.sStudentId
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform