D
D
Dima Sokolov2017-05-06 13:50:28
SQL
Dima Sokolov, 2017-05-06 13:50:28

How to include a field in a query without displaying data in the output?

There is a query SELECT Product.ID, Product.Title AS Product, Category.Title AS Category
FROM Product
INNER JOIN Category ON Product.CategoryID = Category.ID
It is necessary that only the last 2 fields are displayed in the table, and the first one is not displayed. Can this be done using SQL?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
D
Dimonchik, 2017-05-06
@dimonchik2013

SELECT 
t1.чтонадо, t2.что надо  // сюда пишешь из каких таблиц что показывать
FROM table1 t1
INNER JOIN 
table2 t2 
ON t1.column_name = t2.column_name
;

K
kalapanga, 2017-05-06
@kalapanga

SQL has nothing to do with it. Displays data in some table control. In it, and customize the displayed columns as you like.

A
Artyom Karetnikov, 2017-05-06
@art_karetnikov

Lord, why the hell do people start answering if they don't know what they're talking about...
Look: here's your table. Take design mode. Put the cursor on the required field. You set it either:
Width - 0
or Hidden = True + Enable = False
That's it!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question