If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query data from a parent-child table
grupy wrote:
Id like to know how I can query lets say a specific record from a parent-chil table For example, lets say parent table is Products using ProductID as the primar key and its child table is Customer using CustomerID as its key Id like to query one product and all its specific customers into a table b using a query. Can someone pls point me into the appropriate direction? Consider an Invoice. Standard tables for it are something like Customer(CustomerID (PK), CustomerName....) Invoice(InvoiceNo (PK), InvoiceDate, InvCustomerID (FK)...) LineItem(InvoiceNo (PK1), ProductID (PK2), Quantity....) join all the tables on PK/FK. Select Customer.CustomerName, Products.ProductName FROM Customer INNER JOIN Invoice ON Customer.CustomerID = Invoice. InvCustomerID INNER JOIN LineItem ON Invoice.InvoiceNo = LineItem.InvoiceNo WHERE Products.ProductName = "Some Product"; -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|