Search results for query: *

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

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

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

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

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 +...