2 outer joins

[woodyinoz]

Database - SQLBase
Crystal 9

Tables-

Part (Master)
Trace (Child)
Trace_Inv (Child)

Part is linked to Trace through PART_ID and is joined with an outer join (Trace is the table with nulls). This is working fine.
However, I also need to link Trace_Inv to Trace and use an outer join there aswell (Trace_Inv will contain some nulls).

When I do this and try and run my report I get told I can only have one outer join..... I assume that this means I can only use one outer join with the trace table.

Does anyone know how to get around this?? If I can!

Cheers,

Woody

 

[synapsevampire]

It sounds like an issue with your ODBC driver, as you can have multiple LEFT OUTER joins.

You should add the Part table, create the link from it to the Trace table, then link them and under options state Left Outer.

Now add the Trace_Inv, link from the Trace to it, select options for the link and make it a Left Outer. Works fine for most databases.

You're may be better off to construct the SQL yourself and use the Add Command to paste it in, or better yet, create a View on the database.

-k

 

[woodyinoz]

Thanks for that.

Could you explai to me about this Add command?

 

[synapsevampire]

In CR 9 when you open a data source, the first thing you'll see si Add Command, double click it and you'll be able to paste in REAL SQL. It also allows you to define and apply parameters there.

-k