2. ASPRunnerPro General questions
  3. Report with more than 2 different tables
This topic is locked

Report with more than 2 different tables

 		2/21/2008 11:30:57
ASPRunnerPro 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
Sergey Kornilov admin 2/21/2008

I guess you can build a SQL query that pulls data from all three tables and use it as datasource for your report.
C
 		ckapote author 2/22/2008

I guess you can build a SQL query that pulls data from all three tables and use it as datasource for your report.



Thanks ,

Yes I can built a query from 3 tables and pulls data , I need to create a report with Header from tbl crew and a body containing

two seperate tables one from tblexperience and one from tbldiplomas.

Phprunner creates a report with header from tblcrew and body with ONE table containing data from the other two tables in the same row .

Nevertheless I would like to congratulate you once more for your software and your response!