Problem with custom report

Yahoo Archive
1
Outer join ShipHead & ShipDtl.
Rob




________________________________
From: ronnie_h_9 <rhaynes@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 23, 2009 4:47:42 PM
Subject: [Vantage] problem with custom report





Hello,

I'm having a problem with a custom report. It has the following tables in it.

orderdtl
orderhead
orderrel
part
shipto

But when I add the shiphead and shipdtl tables it automatically filters out orders that haven't been shipped. I want to see both orders that have and have not shipped. I know that I have to join those tables differently. Could someone give me an example of a SQL statement joining all the above tables together?
Thanks
Ronnie







[Non-text portions of this message have been removed]
2
Hello,

I'm having a problem with a custom report. It has the following tables in it.

orderdtl
orderhead
orderrel
part
shipto

But when I add the shiphead and shipdtl tables it automatically filters out orders that haven't been shipped. I want to see both orders that have and have not shipped. I know that I have to join those tables differently. Could someone give me an example of a SQL statement joining all the above tables together?
Thanks
Ronnie
3
Use a left join on the join going to shiphed.it should work then.



Thank You,



Brad Ebright
MGS Inc.
178 Muddy Creek Church Rd.
Denver, PA 17517
(717)336-7528

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ronnie_h_9
Sent: Tuesday, June 23, 2009 4:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] problem with custom report








Hello,

I'm having a problem with a custom report. It has the following tables in
it.

orderdtl
orderhead
orderrel
part
shipto

But when I add the shiphead and shipdtl tables it automatically filters out
orders that haven't been shipped. I want to see both orders that have and
have not shipped. I know that I have to join those tables differently. Could
someone give me an example of a SQL statement joining all the above tables
together?
Thanks
Ronnie





[Non-text portions of this message have been removed]