How to create INNER JOIN multiple tables in sql

Question

I have 3 tables: products, suppliers and prices. Prices have product_id and vendor_id as foreign keys. Now I want to show Prices as:

price_id: product_name: seller VENDOR_NAME: price

Sort of:

SELECT p.product, v.vendor, pc.price
FROM Products AS p,
Vendors AS v
INNER JOIN Prices AS pc
ON p.product_id = pc.product_id
INNER JOIN Prices AS pc
ON v.vendor = pc.vendor_id

but i didn't get a job.

Answer 1

Try the following:

SELECT pr.price_id, p.product_name v.vendor_name, pr.price
FROM Prices AS pr
LEFT JOIN Products AS p ON p.product_id = pr.product_id
LEFT JOIN Vendors AS v ON v.vendor = pr.vendor_id

Answer 2

You cannot use the same alias twice

Prices as pc

You can use only once.

Answer 3

3 UNION

Answer 4

, 3 , .

SELECT A.ID_USER,A.NAME,D.ADDRESS,B.ID_STATE,B.STATE,A.ID_COUNTRY,C.COUNTRY 
FROM market.USER A 
    INNER JOIN market.state B
ON   A.ID_STATE=B.ID_STATE 
    INNER JOIN market.country C
ON A.ID_COUNTRY=C.ID_COUNTRY
    INNER JOIN market.contact D
ON A.ID_CONTACT=D.ID_CONTACT

.