On 07/19/2005 10:12 PM Mathew Walker wrote:
I'd go with a UNION. The reason a union is useful is that you want B.content
and C.content to appear as the same column in your record set, which is what
a union does well.
Thanks for your answer. I tried the UNION and it did what I wanted (it pulled
This (http://www.pcreview.co.uk/forums/thread-1138891.php) seems to suggest
that UNION ALL might be your answer.
-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED]
Sent: Thursday, 21 July 2005 6:58 a.m.
To: CF-Talk
Subject: RE: or operator in WHERE statement
On 07/19/2005
Matthew Walker wrote:
This (http://www.pcreview.co.uk/forums/thread-1138891.php) seems to suggest
that UNION ALL might be your answer.
Thanks, that worked. The full field is displayed now. The ALL parameter would
show repeated records, but since in my case both tables are mutually exclusive
You're using Access right? CASE is not supported. You can use iif()
though -- syntax is pretty much the same as in CF.
-Original Message-
From: Roberto Perez [mailto:[EMAIL PROTECTED]
Sent: Thursday, 21 July 2005 11:31 a.m.
To: CF-Talk
Subject: RE: or operator in WHERE statement
Taco
It would be something like
SELECT
CASE A.status
WHEN B.status THEN B.status
WHEN C.status THEN C.status
FROM yourTable
I think that's what you are after.
Taco Fleur - E-commerce Development Manager
Shelco Searches Services
An Authorised ASIC Information Broker
Are you table-scoping the column in your SELECT clause? Perhaps you
could post the whole SQL statement?
cheers,
barneyb
On 7/19/05, Roberto Perez [EMAIL PROTECTED] wrote:
Hi all,
Quick question: is OR a valid operator in a WHERE statement?
I have a main table A with a 'status' field
At 04:25 PM 7/19/2005, you wrote:
Are you table-scoping the column in your SELECT clause? Perhaps you
could post the whole SQL statement?
Mmmm...not sure I'm familiar with table scoping... (maybe you could
elaborate on that)
The SQL itself is straightforward, it is just 3 fields in 3
I'd go with a UNION. The reason a union is useful is that you want B.content
and C.content to appear as the same column in your record set, which is what
a union does well. Note that with unions, the order you list the columns and
the number of columns is critical. Also only add one ORDBER BY
8 matches
Mail list logo
