Answer the question
In order to leave comments, you need to log in
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
SELECT
t1.чтонадо, t2.что надо // сюда пишешь из каких таблиц что показывать
FROM table1 t1
INNER JOIN
table2 t2
ON t1.column_name = t2.column_name
;
SQL has nothing to do with it. Displays data in some table control. In it, and customize the displayed columns as you like.
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 questionAsk a Question
731 491 924 answers to any question