Answer the question
In order to leave comments, you need to log in
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')
Answer the question
In order to leave comments, you need to log in
hmmm, SELECT t1.* FROM Table1... and further down the list should work
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question