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 Chriss Miller 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. Gwynhwfar

    Select using SQL Plus

    Yes this is what I will be doing, once I get the Select stmt bit correct. The one I listed above doesn't work. Doesn't like the last line. I wonder if this is because it's the same table? Thanks
  2. Gwynhwfar

    Select using SQL Plus

    Hi folks, This is the first time I've posted here so please bear with me. I have written the following (to run in SQL Plus) select r.relation, s.stud_id, pl.fullname, sl.fullname, ca.address_id, ca1.address_id from relative r, people p, student s, people_lookup pl...
  3. Gwynhwfar

    info from a table selected by a parameter

    Okay, I could do this, but then how do I get the relevant details from the people table based on this selection (which could be different from that shown by the connection the table current gives). e.g. Student Jim has a Referral related to Mr Brown, BUT the letter needs to go out with Mrs...
  4. Gwynhwfar

    info from a table selected by a parameter

    Not sure if I can do what I want to do. I have the following tables: people (contains ID, name, tel) student (student details) referral (referral details) The referral table is linked to both people and student on their respective IDs. Now I want to produce letters based on the student...
  5. Gwynhwfar

    Cross tab totals

    I have set up a cross tab which has two subcolumns for each column. I want the grand total for each row to total the subcolumns and show me that rather than an overall total: getting: + col1 + col2 + total + + sub1 . sub2 + sub1 . sub2 +...

Part and Inventory Search

Back
Top