tabyla_rasa: (Agata2012)
Кто мне подскажет, как трансформировать эту фигню:

SELECT maker, Product.model AS model_1, PC.model, price
FROM Product INNER JOIN
PC ON PC.model = Product.model
WHERE maker LIKE 'B%'

UNION
SELECT maker, Product.model AS model_1, Laptop.model, price
FROM Product INNER JOIN
Laptop ON Laptop.model = Product.model
WHERE maker LIKE 'B%'

UNION
SELECT maker, Product.model AS model_1, Printer.model, price
FROM Product INNER JOIN
Printer ON Printer.model = Product.model
WHERE maker LIKE 'B%'
ORDER BY maker



чтобы столбцов было не 4 как сейчас

makermodel_1modelprice
B11211121850.0000
B175017501200.0000





а только 2, вот этих:


modelprice
1121850.0000
17501200.0000
From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.