Results 1 to 2 of 2

Thread: Help!

  1. #1
    Join Date
    Dec 1969

    Default Help!

    Here is my situation. I have one table with a list of events. I have another table with a list of people. The third table has the event and the person that went to it. What I am trying to do is select an event and get a list of all the people and whether or not they went to the event. I can do all the joins, but I can&#039t figure out how to get a full list of people and a yes/no if they went or not. Any ideas would be greatly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Help!

    tell me the table names/field names and their relationships to each other and i&#039ll give you a SQL statement for it<BR><BR>jason

Posting Permissions

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