Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: help!

  1. #1
    New to the CF scene
    Join Date
    Jun 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    help!

    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.

  • #2
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?

  • #3
    Regular Coder Crake's Avatar
    Join Date
    Dec 2004
    Location
    Loose, Maidstone, KENT
    Posts
    577
    Thanks
    0
    Thanked 3 Times in 3 Posts
    please change your thread title a little bit more according to the kind of help you need

    also

    HELP!

    is a little demanding dont you think

    good luck with the help you need
    SteveO


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •