Perform a query in SQL avoiding multiplicity [closed]

Question

Perform a query in SQL avoiding multiplicity [closed]

Navigation

#1 by (1 votes)

0

I have a table Producto and a table Proveedor (are related by campoidProducto ).

In this particular case I want a query that results in all the products, and for each product show a provider (a product can have several providers, you only need to show one since it is for a visualization of products).

sql informix

asked by user47431 13.06.2017 в 07:03

source

1 answer

Why did I create two folders (branch and trunk) when downloading a github project in tortoise? how to solve that doubt to save names and ages

score 1 · Answer 1

SELECT * FROM TABLE_PRODUCTS P INNER JOIN TABLE_PROVIDERS PR ON PR.IDPRODUCT = P.IDPRODUCT GROUP BY IDPRODUCT.

This would be the way. It is advisable to show the tests that you have done with the code and give more information about the tables, such as the common field with which to do the INNER JOIN.