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
|
|
|
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
|
|
|
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.
|
|
|
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.
|
|
|
travel-net
Posts: 56
|
Posted: 03/12/2004, 7:08 AM |
|
Sorry,
Invoice has also Customer_id.
Are you Ron from Rbintraweb?
|
|
|
RonB
Posts: 228
|
Posted: 03/12/2004, 7:10 AM |
|
Yep
|
|
|
RonB
Posts: 228
|
Posted: 03/12/2004, 7:11 AM |
|
Windsurf?
|
|
|
travel-net
Posts: 56
|
Posted: 03/12/2004, 7:12 AM |
|
Yep, and Travel-Net
|
|
|
RonB
Posts: 228
|
Posted: 03/12/2004, 7:12 AM |
|
I thought so
Did you look at the invoice join?
|
|
|
travel-net
Posts: 56
|
Posted: 03/12/2004, 7:16 AM |
|
Check Your mail in 5 minutes or so.
|
|
|
RonB
Posts: 228
|
Posted: 03/12/2004, 7:17 AM |
|
OK
|
|
|