Mysql - Select from one query multiple Alias

Question

I have a problem.

I'm using this query:

...
(SELECT TXTVALUE
FROM table 
WHERE
    EXTID = 2
)AS A,

(SELECT TXTVALUE 
FROM table 
WHERE
    EXTID = 4
)AS B
...

So in the end my goal is just call one's the query and create one alias per condition. Right now I have several queries(like this example up) calling the same table and I just need to have one different alias depending the condition.

Thanks in advance.

can you tell us what is the greater goal that you want to achieve ? i order to get the big picture — Stephan
– Stephan, Commented Apr 17, 2013 at 8:32

Mahmoud Gamal · Accepted Answer · 2013-04-17 08:25:01Z

1

I think you might need to use UNION or UNION ALL for this:

SELECT TXTVALUE, EXTID 
FROM table 
WHERE  EXTID = 2
UNION ALL
SELECT TXTVALUE, ECTID
FROM table 
WHERE  EXTID = 4
UNION ALL
....

This will let you specify a column, so that it have a different values depending on the condition under the same column.

SELECT TXTVALUE, EXTID AS 'Types' -- For example
FROM table 
WHERE  EXTID = 2
UNION ALL
SELECT TXTVALUE, ECTID
FROM table 
WHERE  EXTID = 4
UNION ALL
....

answered Apr 17, 2013 at 8:25

Mahmoud Gamal

80.3k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql - Select from one query multiple Alias

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related