bigtoe
Posts: 115
|
| Posted: 10/17/2005, 5:11 AM |
|
I used CCS to create a report.
The report is basically displaying fields
from a MySQL table "T1" like this:
T1.Field1
T1.Field2
T1.Field3
T1.Field4
T1.Field5
But now I need to display fields from another
MySQL table "T8" within this report like this:
T1.Field1
T1.Field2
T1.Field3
T8.Field1
T8.Field3
T8.Field6
T1.Field4
T1.Field5
How should I do this?
|
 |
 |
Alvaro Cobo
|
| Posted: 10/17/2005, 9:13 AM |
|
Hi bigtoe:
You ought to create a SQL query join both tables (either inner join, left
joing, or right joing, dependind on your needs) and then paste this sql
query into the "Data Source" property of the form.
You could also use the "Build Query" tool you can find in the "Data Source"
dialog box. Within this tool you can graphically design your own query.
Hope this helps.
Best regards,
Alvaro
|
|
|
|
|
