2. PHPRunner General questions
  3. [SOLVED]  Difference betwwen Table Link & SQL Join
This topic is locked
[SOLVED]

 Difference betwwen Table Link & SQL Join

 		4/26/2010 10:47:16 PM
PHPRunner General questions
P
 procheck author

Hi,
There are situations where using a table link in Datasource or an SQL Join would accomplish the same thing. I haven't been able to find any explanation of what Table Links really are. I'm using MyISAM so I know it's got nothing to do with foreign keys. Can someone explain the difference?
Thanks
Sergey Kornilov admin 4/27/2010

I guess you asking about the difference between Master-Details relationships and INNER JOIN queries.
In short, Master-Details relationships is a way to link two tables together to provide drilldown capabilities. I.e. you pick a customer, then see all orders placed by this customer, then proceed to the details of any specific order.
INNER JOINs on the other hand allow you to see data from several tables on the same page i.e. see everything related to customers, orders and order details on the same screen as a single table.
P
 		procheck author 4/27/2010

Thank-you!