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!

Register Log in
  • Congratulations TouchToneTommy 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
  • Content: Threads
  • Order by date
  1. postmannie

    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
  2. postmannie

    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

Part and Inventory Search

Back
Top