SP v Subreports A to B A to C...linking

[codrutza]

I am working with CRXI on SQL Server
I have this linking situation:
tableA.number=tableB.number (1:n)
tableA.number=tableC.number (1:n)
tableA.number=tableD.number (1:n)
I need data from all tables
I know I can solve this with subreports, but I want to write a stored procedure and I am completely beginner in this
Can I have some sugestions?
Thank you

 

[Madawc]

What's wrong with simple linking from A to B, C and D? If you use left-outer links, you will still get data if one or more of these are missing.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[codrutza]

Thank you fo reply.
If I link like this, then won't I have a cartezian product?
The joining field is the same for all links

 

[Madawc]

Sorry, I don't follow your reply.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10