OK Here's what I have. 2 Tables, the first table (COMPANY) holds data for companies and its primary key is C_ID) The second table (ACTIVITY) which holds activities and has a primary key of A_I*D and a foreign key named C_NUMBER which references the other tables primary key (C_ID). I'm trying to perform a search by company name (Which I have working well) I'm also trying to search by a certain activity date which should return all the activities scheduled on that date, along with their coresponding companies. Can you help me develop a sql query that would return the activity date (A_DATE) along with its C_NUMBER so I can put this info into a tabular format, so it could be read on the next page?
Thanks and sorry my explanation is so long.