2. PHPRunner General questions
  3. [SOLVED]  Linked names fields
This topic is locked
[SOLVED]

 Linked names fields

 		6/28/2011 5:34:45 AM
PHPRunner General questions
R
 rocknroll_france author

Hi,

Newbye with Phprunner... LOL

I have 2 linked tables. In the final report, I would like to have the names of the master table AND the NAMES of some fieds of the linked table.

At this time, I only have the master table and link to the detail (linked) table
Example:
Master table:

IdUser

Name

adress

...
Detail table

Iddetail

Id

Num1

Car

...
Field "Id" in detail table = field IdUser in master table....
I would like to have a "report" with (for example !)

Name (master table) - adress (master table) - Num1 and Car (detail table) clearly write... and not a link to these details.
Thanks for answers... And sorry for maybe this newbye question.
Rocknroll
C
 		cgphp 6/28/2011

rocknroll,
in the SQL builder of the report join the two tables:

SELECT

master.name,

master.address,

detail.num1,

detail.car

FROM master

INNER JOIN detail ON master.IdUser = detail.Id



master and detail are the name of your tables.
R
 		rocknroll_france author 6/28/2011

Thanks cgphp...

I did not see it was possible to link tables in the "query" view of PHPRUNNER .......

I tried to open the tables on the "tables" view, to make links between them.... So it was not possible to have the informations I looked for.
It works fine now...
a newbie steel a newbie LOL !
Sorry for my poor english