Hi
I try to run the following query..
SELECT
(SELECT DISTINCT Artno, L, D, CreatedBy FROM dbo.tbl_Art WHERE (L = N'SE')) AS SE,
(SELECT DISTINCT Artno, L, D, CreatedBy FROM dbo.tbl_Art WHERE (L = N'GB')) AS GB
FROM dbo.tbl_Art
But I get a error message telling me..."only one expression...