How to Retrive data from multipue tables by the purpose of creating datareports? And How to sum One field ? It contains MultiPul records .How to write a query in command proparties in connection proparties In datareports.
mysql manual, look up join
Yes Inner Joins sounds about right
$sql="SELECT table1.,table2. FROM table1 INNER JOIN table2 ON table1.pk=table2.fk WHERE whatever='$whatever'";
Ahh the joys of SQL!
pk=primary key fk=foreign key
