Create Table Question

atmosphere · #1 (**permalink**) 09-20-04, 11:21

Hi

Im wondering if someone could help me out with how to write sql for the following type of query.

I have 3 known strings of characters and three associated sql queries. The queries will always return an integer.

I want a table so that column 1 is the list of known strings, and column 2 is the results of the three queries.

Thank you

r937 · #2 (**permalink**) 09-20-04, 17:35

create table mytable
( string varchar(100)
, result integer
)

LKBrwn_DBA · #3 (**permalink**) 09-22-04, 16:25

Or maybe something like this:

Code:

create table mytable
( string varchar(100)
, result integer)
AS
select string, SUM(result) from (
    select string, result from query1
    UNION ALL
    select string, result from query2
    UNION ALL
    select string, result from query3)
 group by string;

Internet Services

Web Development

Digital Marketing

Consumer Tech