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 strongm 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: *

  1. postmannie

    trigger

    rac2 thanks for the reply, unfortunately it does not work. Using sybase if that helps. thanks in advance
  2. 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
  3. 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