Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: postmannie
- Order by date
-
trigger
rac2 thanks for the reply, unfortunately it does not work. Using sybase if that helps. thanks in advance- postmannie
- Post #3
- Forum: ANSI_SQL
-
trigger
Struggling with this one, Got two tables Student (national_insurance_nos,name,date_of_birth,room_nos) ClassRoom (room_nos,builing_name,number_of_seats) Trigger required for a constraint - number of students cannot be greater than the number of seats in a class room thanks in advance- postmannie
- Thread
- Replies: 2
- Forum: ANSI_SQL
-
SELECT patient_no, room_no, employe
SELECT patient_no, room_no, employee_no, department FROM patient RIGHT OUTER JOIN dentist ON dentist_no = employee_no Is there any way to produce a query using UNION for the above statement (no join) Cheers PM- postmannie
- Thread
- Replies: 2
- Forum: ANSI_SQL
