Hidding column in query

[W. Adam]

Here is my code.

SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
[Condo].[Weekly Rate], [Condo].[Linens]

FROM [Owner], [Condo]

WHERE [Condo].[Linens]=True

AND [Owner].[Owner ID]=[Condo].[Owner ID]

ORDER BY [Condo].[Unit Number];





I am trying to not display "Linens" column in my query result.Any idea how
can i achive that. Thanks in advance

[Erland Sommarskog]

Re: Hidding column in query

W. Adam (wogla@sbcgloba l.net) writes:[color=blue]
> Here is my code.
>
> SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
> [Condo].[Weekly Rate], [Condo].[Linens]
> FROM [Owner], [Condo]
> WHERE [Condo].[Linens]=True
> AND [Owner].[Owner ID]=[Condo].[Owner ID]
> ORDER BY [Condo].[Unit Number];
>
> I am trying to not display "Linens" column in my query result.Any idea how
> can i achive that. Thanks in advance[/color]

Well, just don't display it!

Seriously, this is likely to be a GUI issue, and you should probably
ask in a forum devoted to the GUI tool you are using.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[BenignVanilla]

Re: Hidding column in query


"W. Adam" <wogla@sbcgloba l.net> wrote in message
news:tL5Cb.1123 6$aw2.5741825@n ewssrv26.news.p rodigy.com...[color=blue]
> Here is my code.
>
> SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
> [Condo].[Weekly Rate], [Condo].[Linens]
>
> FROM [Owner], [Condo]
>
> WHERE [Condo].[Linens]=True
>
> AND [Owner].[Owner ID]=[Condo].[Owner ID]
>
> ORDER BY [Condo].[Unit Number];
>
>
>
>
>
> I am trying to not display "Linens" column in my query result.Any idea how
> can i achive that. Thanks in advance[/color]

There are two answers to this question. The first being, just don't select
the field

SELECT [Owner].[First Name], [Owner].[Last Name], [Condo].[Unit Number],
[Condo].[Weekly Rate]
FROM [Owner], [Condo]
WHERE [Condo].[Linens]=True
AND [Owner].[Owner ID]=[Condo].[Owner ID]
ORDER BY [Condo].[Unit Number];

- or -

If you need the linens value but don't want to display it, handle this in
business layer (class, dll, module, mts, etc.), or your presentation layer
(application, web page, etc.).

BV.

https://www.iheartmypond.com