Export utility - left outer join?

Yahoo Archive
1
Try this :

Cut and paste this in the Export Query then select the fields you want.

for each Vendor Where Vendor.Company = cur-comp no-lock,
each VendGrup Where VendGrup.Company = Vendor.Company
and VendGrup.GroupCode = Vendor.GroupCode no-lock:

I am able to pull all fields in these tables
Don Kolllmann
Wisconsin EPS

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, September 13, 2000 4:45 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Export utility - left outer join ???



At 04:43 PM 9/13/2000 , you wrote:
>I can't duplicate your problem ... my export query looks different
>from yours. Mine comes out as:

Yup, that looks like what the wizard thing generated. It produces the
inner-join effect, where the vendors with no code are excluded. When it
didn't work, I looked over the syntax description in the online help. I
left out the WHEREs and BYs; then tried omitting EACH, using the OF
VENDOR, and what not.

And Don asked:
>What information are you looking to pull
>Just vendors name and group description?

Vendor name, address, CSZ, and some other Vendor table fields, as well as
the group description, and possibly some other joined tables later.

-Thanks,
WC


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
2
Wayne,
I can't duplicate your problem (it looks like my purchasing group
has actually entered groups for everything... Usually when I go poking
through the data like this, it's like looking under a rock: I always find
something slimy). However, I did notice that my export query looks different
from yours. Mine comes out as:

for each Vendor Where Vendor.Company = cur-comp no-lock,
each VendGrup Where VendGrup.Company = Vendor.Company
and VendGrup.GroupCode = Vendor.GroupCode no-lock
BY VendGrup.GroupCode:

Don't know if that makes a difference...

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, September 13, 2000 3:15 PM

I'm having decent luck making simple exports work. But doing joins is
giving me headaches. I want to dump all vendors, along with their
GroupCode and VendGrup.Description. Some Vendors don't have a group code
(that's where the trouble starts)

for each Vendor Where Vendor.Company = cur-comp no-lock,
each vendgrup of vendor:
3
-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, September 13, 2000 3:15 PM
To: vantage@egroups.com
Subject: [Vantage] Export utility - left outer join ???


Hi Wayne
What information are you looking to pull
Just vendors name and group description?

Don Kollmann
Wisconsin EPS
Database Analyst

Hmm, been spending a bunch of time messing with the export utility this
afternoon, and just fired up email after a couple hours. Looks like
someone else is having the same struggle today :)

I'm having decent luck making simple exports work. But doing joins is
giving me headaches. I want to dump all vendors, along with their
GroupCode and VendGrup.Description. Some Vendors don't have a group code
(that's where the trouble starts)

for each Vendor Where Vendor.Company = cur-comp no-lock,
each vendgrup of vendor:

Behaves like an Inner Join and DOES NOT export the Vendors with a null
GroupCode.

Other stuff I tried generated run time errors, or duplicated vendors X
every VendGrup, and other useless stuff.

Can anyone tell me how to make it behave like a Left Outer Join ?


Thanks, -Wayne Cox

PS... just to make things more aggravating, Vantage leaves the export
file locked sometimes, so you have to rename it with each try. arrgh!
4
Wayne,

Go here ---> http://www.progress.com/support/techpapers/query.htm
<http://www.progress.com/support/techpapers/query.htm>

What you will find is the "Engine Crew Monographs" --- probably another
obscure drinking thing within Progress.

These are what you would call "White Papers". Or "Query Documentation for
us dummies ..."

At any rate - it's a first rate bit of documentation JUST about query
strategies and formats.

Hope it helps

Todd Anderson
J. Rubin & Co.

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, September 13, 2000 3:15 PM
To: vantage@egroups.com
Subject: [Vantage] Export utility - left outer join ???




Hmm, been spending a bunch of time messing with the export utility this
afternoon, and just fired up email after a couple hours. Looks like
someone else is having the same struggle today :)

I'm having decent luck making simple exports work. But doing joins is
giving me headaches. I want to dump all vendors, along with their
GroupCode and VendGrup.Description. Some Vendors don't have a group code
(that's where the trouble starts)

for each Vendor Where Vendor.Company = cur-comp no-lock,
each vendgrup of vendor:

Behaves like an Inner Join and DOES NOT export the Vendors with a null
GroupCode.

Other stuff I tried generated run time errors, or duplicated vendors X
every VendGrup, and other useless stuff.

Can anyone tell me how to make it behave like a Left Outer Join ?


Thanks, -Wayne Cox

PS... just to make things more aggravating, Vantage leaves the export
file locked sometimes, so you have to rename it with each try. arrgh!
5
At 04:43 PM 9/13/2000 , you wrote:
>I can't duplicate your problem ... my export query looks different
>from yours. Mine comes out as:

Yup, that looks like what the wizard thing generated. It produces the
inner-join effect, where the vendors with no code are excluded. When it
didn't work, I looked over the syntax description in the online help. I
left out the WHEREs and BYs; then tried omitting EACH, using the OF
VENDOR, and what not.

And Don asked:
>What information are you looking to pull
>Just vendors name and group description?

Vendor name, address, CSZ, and some other Vendor table fields, as well as
the group description, and possibly some other joined tables later.

-Thanks,
WC