On Mon, Jan 25, 2016 at 9:32 PM, Larry Martell
wrote:
> On Mon, Jan 25, 2016 at 8:26 PM, Johnny Withers
> wrote:
> > You should probably turn this into a UNION and put an index on each
> column:
> >
> > SELECT f_tag_ch_y_bottom AS ftag FROM data_cst WHERE f_tag_ch_y_bottom =
> > 'E-CD7'
> > UNIO
On Mon, Jan 25, 2016 at 8:26 PM, Johnny Withers wrote:
> You should probably turn this into a UNION and put an index on each column:
>
> SELECT f_tag_ch_y_bottom AS ftag FROM data_cst WHERE f_tag_ch_y_bottom =
> 'E-CD7'
> UNION ALL
> SELECT f_tag_ch_x_bottom AS ftag FROM data_cst WHERE f_tag_ch_x_
On Mon, Jan 25, 2016 at 8:01 PM, Rebecca Love wrote:
> Have you tried using a select case statement for ftag?
How would that help? Unless I'm missing something, I'd still have to
have a reference to the column alias in the where clause.
>> On Jan 25, 2016, at 6:39 PM, Larry Martell wrote:
>>
>
You should probably turn this into a UNION and put an index on each column:
SELECT f_tag_ch_y_bottom AS ftag FROM data_cst WHERE f_tag_ch_y_bottom =
'E-CD7'
UNION ALL
SELECT f_tag_ch_x_bottom AS ftag FROM data_cst WHERE f_tag_ch_x_bottom =
'E-CD7'
UNION ALL
SELECT f_tag_bottom_minor_axis AS ftag F
Have you tried using a select case statement for ftag?
> On Jan 25, 2016, at 6:39 PM, Larry Martell wrote:
>
> On Mon, Jan 25, 2016 at 7:27 PM, Reindl Harald wrote:
>>
>>
>> Am 26.01.2016 um 01:16 schrieb Larry Martell:
>>>
>>> I know I cannot use an alias in a where clause, but I am trying
On Mon, Jan 25, 2016 at 7:27 PM, Reindl Harald wrote:
>
>
> Am 26.01.2016 um 01:16 schrieb Larry Martell:
>>
>> I know I cannot use an alias in a where clause, but I am trying to
>> figure out how to achieve what I need.
>>
>> If I could have an alias in a where clause my sql would look like this:
Am 26.01.2016 um 01:16 schrieb Larry Martell:
I know I cannot use an alias in a where clause, but I am trying to
figure out how to achieve what I need.
If I could have an alias in a where clause my sql would look like this:
SELECT IFNULL(f_tag_bottom,
IFNULL(f_tag_bottom_majo
I know I cannot use an alias in a where clause, but I am trying to
figure out how to achieve what I need.
If I could have an alias in a where clause my sql would look like this:
SELECT IFNULL(f_tag_bottom,
IFNULL(f_tag_bottom_major_axis,
IFNULL(f_tag_bottom_minor_
