In RB in the editing screen you can do Ctrl-Alt-P then F12 to see SQL code. I've noticed sometimes a slight pause between Ctrl-Alt-P and the F12 is needed.
Also, if linking CustCnt to Order it might do this whereas linking Order to CustCnt should not with an Outer join. Maybe it's direction dependent?
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Ben Belzer
Sent: Tuesday, November 29, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Query
Yes, there is a left outer join. That is what I had tried first, and it
still returns only those with a ConNum over 0. (eliminating or not
showing 0's)
I have 6.1 but have never used RB. I was hoping never to have to due to
its phase-out.
I'll give it a shot though...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Tuesday, November 29, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Query
Not that familiar with queries but isn't there a way to do a left outer
join on the table link to CustCnt that will take all orders regardless
of whether there is a contact to link to or not? Might be called just
"outer join". If there is none then it should return an unknown value
such as ? for the contact. If this is for 6.1 and you have RB you can
try something similar and then view the SQL code that should be about
the same for a query or provide some suggestions to try.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Ben Belzer
Sent: Tuesday, November 29, 2005 4:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Query
Hi Everyone,
I am trying to write a simple query that lists the Order Number with the
Contact Name.
This query only returns those sales orders where a contact has been
selected. For those where PrcConNum = 0, it fails to return a name.
Which I do understand because the CustCnt table won't have a ConNum of
0.
The question I have is how can I create the query to show me the contact
name, and if no name exists show me something in its place ("No
Contact", 0, NULL etc...)
I am using Microsoft Query, unless someone has something they recommend
more.
Thanks in advance,
Ben
Ben Belzer
IT Manager
TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com < http://www.tciprecision.com/>
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu> &k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Also, if linking CustCnt to Order it might do this whereas linking Order to CustCnt should not with an Outer join. Maybe it's direction dependent?
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Ben Belzer
Sent: Tuesday, November 29, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Query
Yes, there is a left outer join. That is what I had tried first, and it
still returns only those with a ConNum over 0. (eliminating or not
showing 0's)
I have 6.1 but have never used RB. I was hoping never to have to due to
its phase-out.
I'll give it a shot though...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Tuesday, November 29, 2005 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales Order Query
Not that familiar with queries but isn't there a way to do a left outer
join on the table link to CustCnt that will take all orders regardless
of whether there is a contact to link to or not? Might be called just
"outer join". If there is none then it should return an unknown value
such as ? for the contact. If this is for 6.1 and you have RB you can
try something similar and then view the SQL code that should be about
the same for a query or provide some suggestions to try.
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Ben Belzer
Sent: Tuesday, November 29, 2005 4:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Order Query
Hi Everyone,
I am trying to write a simple query that lists the Order Number with the
Contact Name.
This query only returns those sales orders where a contact has been
selected. For those where PrcConNum = 0, it fails to return a name.
Which I do understand because the CustCnt table won't have a ConNum of
0.
The question I have is how can I create the query to show me the contact
name, and if no name exists show me something in its place ("No
Contact", 0, NULL etc...)
I am using Microsoft Query, unless someone has something they recommend
more.
Thanks in advance,
Ben
Ben Belzer
IT Manager
TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com < http://www.tciprecision.com/>
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Manufacturing
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu> &k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man> &k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf> &k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
Pda
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur> &k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database
software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man> &k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
< http://groups.yahoo.com/gads?t=ms <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu> &k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage
< http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
________________________________
YAHOO! GROUPS LINKS
* Visit your group "vantage
< http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]