This topic is locked

Report One-Mnay relationship

2/21/2008 1:54:32 PM
PHPRunner General questions
C
ckapote author

Dear All , Hi
Please note that I have three (3) tables :
tblcrew:

idc

Name

Surname
tbldocuments:

idd

Document

Type

connect1
tblexperinece

ide

Experience

Date

connect2
I have created two different queries one between tblcrew and tbldocuments

and one between tblcrew and tblexperience.

Master table in both queries is tblcrew and connected with the other via connect1 and connect2 fields.
I need to create a report with header of tblcrew ( Name and Surname) and the details from the other two tables.

All in the same report .
Can you help ??

Thanks

J
Jane 2/22/2008

Hi,
you can join your tables on the Edit SQL query tab in the PHPRunner.