Re: Complex select across multiple tables

2005-11-16 Thread SGreen
Scott Haneda <[EMAIL PROTECTED]> wrote on 11/16/2005 05:44:05 AM: > Some of these tables are rather large, I would put the schema in there, but > I think it just adds to the mess. > > Tables > `users` field id is auto inc pk > `orders` field id is auto inc pk > `products` field id is auto inc pk

Complex select across multiple tables

2005-11-16 Thread Scott Haneda
Some of these tables are rather large, I would put the schema in there, but I think it just adds to the mess. Tables `users` field id is auto inc pk `orders` field id is auto inc pk `products` field id is auto inc pk `order_items` field order_id is the key for hooking up order_items to orders, al