View Full Version : help!

06-12-2005, 03:21 AM
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.

Kid Charming
06-12-2005, 03:34 AM
I don't think I understand exactly what you're asking for -- do you want a list of all activity dates and their c_numbers, or a list of all activities and their companies for a specific date?

06-12-2005, 12:39 PM
please change your thread title a little bit more according to the kind of help you need



is a little demanding dont you think :eek:

good luck with the help you need :thumbsup: