OT: Can't use UNION

2002-09-24 Thread Paul Giesenhagen
I am putting together an application and I canot use UNION, here is my query that I have used in the past, does anyone have a solution that would not use UNION? SELECT state, state_abv FROM #request.taxStateTable# UNION ALL SELECT province AS state, province_abv AS state_abv FROM #request.taxCan

Re: OT: Can't use UNION

2002-09-25 Thread Jochem van Dieten
Paul Giesenhagen wrote: > I am putting together an application and I canot use UNION, here is my query that I >have used in the past, does anyone have a solution that would not use UNION? > > SELECT state, state_abv > FROM #request.taxStateTable# > UNION ALL > SELECT province AS state, province_

Re: OT: Can't use UNION

2002-09-25 Thread Paul Giesenhagen
v3.2.3 doesn't support FULL OUTER JOIN... Jochem .. I thought you had it for me, dang! Paul Giesenhagen QuillDesign - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 20

Re: OT: Can't use UNION

2002-09-25 Thread Tyler Silcox
TECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 9:53 AM Subject: Re: OT: Can't use UNION v3.2.3 doesn't support FULL OUTER JOIN... Jochem .. I thought you had it for me, dang! Paul Giesenhagen QuillDesign - Original Message - From: &q

Re: OT: Can't use UNION SOLVED (kinda)

2002-09-25 Thread Paul Giesenhagen
- Original Message - From: "Tyler Silcox" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 9:41 AM Subject: Re: OT: Can't use UNION > Paul, are you using CFMX? Because you could run your separate queries and > th