Query to return mutliple rows for hardcoded data

tiger66 · #1 (**permalink**) 10-23-11, 21:03

Hi

I am just wondering if it is possible to split one row of data to two rows in sybase without running the same query twice?

For example, I have a select statement for STORE1
select "STORE1", a.itemName, b,itemQuantity
from Item a, ItemCount b
etc...

My output would look like
"STORE1", Candy, 12

Can I use the same query to also return the same value for store 2 without running the query twice?
i.e. the result would look like
"STORE1", Candy, 12
"STORE2", Candy, 12
"STORE1", Gum, 3
"STORE2", Gum, 4

Many thanks for your input

pdreyer · #2 (**permalink**) 10-24-11, 09:37

Looking for something like this?

Code:

SELECT f.store, o.id, o.name 
FROM sysobjects o
, (SELECT 1 UNION ALL SELECT 2 )f(store)
WHERE id <5

Internet Services

Web Development

Digital Marketing

Consumer Tech