Re: join assistance

2004-02-27 Thread Roger Baklund
* Michael Collins Using the latest MySQL 4. I could use some help on performing a join but not retrieving all the records of the child table. I have a set of tables, the ones involved in this are related as follows: members (one) - (many) orders (one) - (many) orderitems The end result

join assistance

2004-02-26 Thread Michael Collins
Using the latest MySQL 4. I could use some help on performing a join but not retrieving all the records of the child table. I have a set of tables, the ones involved in this are related as follows: members (one) - (many) orders (one) - (many) orderitems The end result should be a list of