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
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_
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
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
- 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
5 matches
Mail list logo