On Wednesday 11 December 2002 17:12, Jeff Snoxell wrote:
> I've worked with a database system in the past that allows you to setup
> permanent joins between two tables in a database such that if you select
> record 1 say on a parent table and then add records to a child table, the
> child table automatically knows that this record is a sub-record of record
> 1 in the parent. Thus I can have databases with table structures like:
> Customers: Orders: OrderedItems
> Without having to always execute complex SQL queries every time.
> Can I do anything with MySQL to make it act in the same way?
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net