Query Help

[nick2price]

I am not sure how to mark my last thread as solved, so if comone tells me i can do this.  Thanks to everyone who helped in my last problem, it was solved with the code

SELECT DISTINCT S.EventNo, E.cno, C.CName
FROM Hiring_Small_Items S
    INNER JOIN Hiring_Large_Items L
        ON S.EventNo = L.EventNo
    INNER JOIN Events E
        ON S.EventNo = E.EventNo 
    INNER JOIN Customers C
        ON E.Cno = C.Cno
ORDER BY S.EventNo

 

Now i am trying to find other ways of querying.  I have a table which i need to select several columns from. So i have done this;

SELECT StockNo, Description, S_Size, SupplierNo 
FROM Stock 
WHERE S_Size='small';

 

Now I want to use the SupplierNo to get the SupplierName from the Supplier table.  How would i follow up this code with simular code from the top to do this?  Or would i need to take another approach?

[AndyB]

I am not sure how to mark my last thread as solved, so if comone tells me i can do this.

 

At the bottom of the page, you should see a link named 'TOPIC SOLVED'. One click does it.

[nick2price]

Thats kool, any help on the sql query?

[zenag]

have u assigned SupplierNo as foreign keys in Supplier table?

[zenag]

IF U ASSIGNED SupplierNo AS FOREIGN KEY IN SUPPLIER TABLE ....

u can do like.....

SELECT Stock.StockNo, Stock.Description, Stock.S_Size, Stock.SupplierNo ,Supplier.SupplierName

FROM Stock LEFTJOIN Supplier ON Stock.SupplierNo=Supplier.SupplierNo

WHERE Stock.S_Size='small';