MySQL table joins

I'm not sure I understand what you mean. Try to reformulate your question.

Is it better to create a master-detail relationship between two tables in MySQL using phpMyAdmin or create the master-detail relationship between two tables in phprunner 6.1 itself or does it matter which way you create it?
HTH
Thanks,

TD

Anyone?

I'm not sure what you mean when you say: "Is it better to create a master-detail relationship between two tables in MySQL using phpMyAdmin or create the master-detail relationship between two tables in phprunner 6.1"

You can create tables and their structure in the "Tables" section of PHPrunner but some db tool like PHPmyadmin are more comfortable.

In PHPmyadmin you define the structure of the database and in PHPrunner you link tables (master-details) to see records and linked records in a particular way.

You can link the tables using phpMyAdmin also. That is what I am asking...which way is best ...link the tables using phpMyAdmin or wait and do it within phprunner?
HTH

TD

Still not quite certain specifically what you are asking; however, I'll take a stab at where I think you're headed.
If you are talking about setting up foreign keys in mysql there are a couple advanages over using only phprunner to define those relationships.

1. Constraints are enforced at the DB level - so changes made using other DB tools will comply with the same constraints
   
2. Changes to the master can propogate (cascade) to the children - changes to the master key also change any references
   
3. Deletes to the master can propogate (cascade) to the children - deleting the master key also deletes dependent children
   

There probably more advantages/differences ... YMMV
Generally, these basic relationships are picked up by phprunner.