var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Brand New to SQL and Programing
I am new to programing and learning via the "trial by fire" method.
The program I am using is based on Pascal and SQL statements. The database responds to SQL statements okay. It is not a Microsoft Program.
Operating system is NT 4.0
Need to find out the total number of each status type for this class.
Table Name: Registrations
Field Name: EnrolSTATUS
Field Name: Class_OID (the class number I am working on is 1300)
The status have 4 different types
0 = enrolled
1 = finished
2 = cancelled
3 = No Show
<Didn't Work Statement>
SELECT * FROM REGISTRATIONS WHERE REGISTRATIONS.CLASS_OID = 1300 AND
Count(*) REGISTRATIONS.EnrolSTATUS = 1
I am hoping this makes more sense to someone else.