CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 MySQL - Need Advice in Query Builder

Print topic Send  topic

Author Message
travel-net

Posts: 56
Posted: 03/12/2004, 5:02 AM

Hello,

The following is the Problem.

I have one master Table with Customer Data:
TableName: Customer
Customer_id
Customer Name
Customer Place
Etc.
Number off records: 2200

Than i have multiple Tables linked to the customer_id like:

TableName: Subscription
Subscription_id
Customer_id
Description
Etc.
Number off records: 2500

TableName: Email
Email_id
Customer_id
Email
Etc.
Number off records: 3000

TableName: Invoice
Invoice_id
Invoice
Amount
Etc.
Number off records: 200

The Table Customer has 2000 Records in it so in the Review Data Tab it should at least show 2000 Records. I tried left / right / inner Joins but i don't get a good result set.

All the links point to the Customer table and it looks like Mysql can't handle this. If i link one table to the Customer Table i get off course a good result set but if 2 or more tables are linked to the Customer table based on the Customer_id link it's not.

I can't use stored procedures/views because i'm using Mysql 3.23.x

Can someone help me out with this?

Regards,
Frans

View profile  Send private message
RonB

Posts: 228
Posted: 03/12/2004, 6:29 AM

Ok first the stupid question:

Did you notice the review data tab limit's the return to 100 rows unless you change the figure?

Sorry I just had to ask :-)

View profile  Send private message
travel-net

Posts: 56
Posted: 03/12/2004, 6:58 AM

Quote :
Ok first the stupid question:

Did you notice the review data tab limit's the return to 100 rows unless you change the figure?

Sorry I just had to ask
Yep, i use the query builder from within CodeCharge and i'm aware of all it's buttons etc.. For testing the SQL i use MySQL Front and the EMS Mysql Manager.
View profile  Send private message
RonB

Posts: 228
Posted: 03/12/2004, 7:04 AM

Again sorry but I've made mistakes like that to many timer so i had to ask. People tend to look at the difficult solution before thinking of things like this :-)

Looking at the tables I see only one thing that strikes me:
- the invoice table does not have a customer_id field (at least you didn't list it)
- did you look at all the joins? If you did a straight join on invoice the max number of rows would be 200.
View profile  Send private message
travel-net

Posts: 56
Posted: 03/12/2004, 7:08 AM

Sorry,

Invoice has also Customer_id.

Are you Ron from Rbintraweb?
View profile  Send private message
RonB

Posts: 228
Posted: 03/12/2004, 7:10 AM

Yep
View profile  Send private message
RonB

Posts: 228
Posted: 03/12/2004, 7:11 AM

Windsurf?
View profile  Send private message
travel-net

Posts: 56
Posted: 03/12/2004, 7:12 AM

Yep, and Travel-Net
View profile  Send private message
RonB

Posts: 228
Posted: 03/12/2004, 7:12 AM

I thought so :-)

Did you look at the invoice join?
View profile  Send private message
travel-net

Posts: 56
Posted: 03/12/2004, 7:16 AM

Check Your mail in 5 minutes or so.:-D
View profile  Send private message
RonB

Posts: 228
Posted: 03/12/2004, 7:17 AM

OK :-)
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.