Ask Experts Questions for FREE Help !
Ask
    mastech's Avatar
    mastech Posts: 1, Reputation: 1
    New Member
     
    #1

    Mar 7, 2003, 09:02 AM
    How do I do an Inner join in MySQL?
    Please could someone assist?
    hswes's Avatar
    hswes Posts: 4, Reputation: 1
    New Member
     
    #2

    Apr 4, 2003, 06:05 PM
    inner join
    You must write
    Select Orders.*, Products.* FROM Orders INNER JOIN
    (OrderDetails INNER JOIN Products ON
    (Prodcts.ProductID = OrderDetails.ProductID) ON
    (Orders.OrderID = OrderDetails.OrderID)
    Where OrderDetails.orderid="&orderid&" and not processed"
    Otherwise you get only the items from the Orders Table

    Good luck

    Hswes

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

MySQL Tutorials [ 2 Answers ]

This website hosts over a dozen MySQL Tutorials: PICKaTUTORIAL.COM -- Free online open source mySQL / SQL (Structured Querry Language) database programming tutorials / articles / guides and more!

MySQL Databases [ 3 Answers ]

I'm cleaning up my website accounts. I use cPanel. I have a list of databases, some of which I'm sure I'm not using... Clearly I've not been smart about naming some of them... How can I verify what the databases are for? Yep, I'm a dummy. Am I making sense?

MYSql Books [ 2 Answers ]

Please name few mysql books for beginners

C++ and mysql [ 2 Answers ]

I want a query that can select all names in a table and write it in sequential form in a listbox of a form in C++.the connection is well established and communication between my system and my datbase is working fine. here is the statement I used: requestName = SELECT SystemName FROM System;...


View more questions Search