Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
October 31, 2004, 5:41 pm
rate this thread
They are 'players' and 'coaches.'
Both types are 'customers' and have several basic fields in common.
But each also has distinct fields.
How do I write the code that selects from the overall 'customers'
table only those records which have "yes" in the "coach" field?
- Tim Van Wassenhove
November 1, 2004, 3:47 am
Re: Newbie question...display records based on field value
Assuming you have
customer(customer_ID, common fields);
player(customer_ID, fields for players);
coach(customer_ID, fields for coaches)
INNER JOIN customer ON coach.customer_ID=customer.customer_ID
Met vriendelijke groeten,
Tim Van Wassenhove <http://www.timvw.info