Dump BAQ Question

Yahoo Archive
1
I am trying to move this query from Excel to a BAQ and Crystal Report.
The goal is to do as much as possible within Vantage.



SELECT DISTINCT PartDtl_0.PartNum AS 'Part Number',
PartDtl_0.PartDescription AS 'Description', Customer_0.Name AS
'Customer', PartBin_0.OnhandQty AS 'On Hand'

FROM PUB.Customer Customer_0, PUB.PartBin PartBin_0, PUB.PartDtl
PartDtl_0

WHERE Customer_0.Company = PartBin_0.Company AND Customer_0.Company =
PartDtl_0.Company AND PartBin_0.Company = PartDtl_0.Company AND
PartBin_0.PartNum = PartDtl_0.PartNum AND PartDtl_0.CustNum =
Customer_0.CustNum AND ((PartBin_0.WarehouseCode='FGS'))

ORDER BY PartDtl_0.PartNum, Customer_0.Name



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Wednesday, February 17, 2010 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Dump BAQ Question





Not that I'm aware of.

What are you attempting to do a select distinct on?

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of timdines@... <mailto:timdines%40ymail.com>
Sent: Wednesday, February 17, 2010 1:08 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Dump BAQ Question

Is there a way to say 'Select Distinct' in a BAQ?

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





[Non-text portions of this message have been removed]
2
Is there a way to say 'Select Distinct' in a BAQ?
3
Not that I'm aware of.



What are you attempting to do a select distinct on?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of timdines@...
Sent: Wednesday, February 17, 2010 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Dump BAQ Question





Is there a way to say 'Select Distinct' in a BAQ?





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