C
C
CityzenUNDEAD2020-09-25 10:34:30
SQL
CityzenUNDEAD, 2020-09-25 10:34:30

How to display all fields of only one table joined by join?

Hello everyone!
The bottom line is this, I'm trying to combine 3 tables, but only the fields of one of them need to be displayed.

SELECT * FROM Table1 t1
JOIN Table2 t2
ON(t1.ID = t2.ID)
JOIN table3 t3
ON(t2.Id = t3.Id)
WHERE t3.Field IN( 'А83', 'А84')

I need to somehow display all the fields of only the Table1 table, and now the fields of all tables are displayed.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitaly Voloboev, 2020-09-25
@CityzenUNDEAD

hmmm, SELECT t1.* FROM Table1... and further down the list should work

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question