Re: [GENERAL] Joining one-to-one and one-to-many tables

2010-03-12 Thread Jeff Ross
Garrett Murphy wrote: Jeff: I may not fully understand the situation or the data you're trying to retrieve, but if you're trying to get "show me all trainers whose current status is Pending", I would go backwards to how you're doing it. If you're only concerned about those records with tr_da

Re: [GENERAL] Joining one-to-one and one-to-many tables

2010-03-11 Thread Garrett Murphy
Jeff: I may not fully understand the situation or the data you're trying to retrieve, but if you're trying to get "show me all trainers whose current status is Pending", I would go backwards to how you're doing it. If you're only concerned about those records with tr_date_name = Pending, then