Primary key and foreign key

Question

I create two tables. One is StockAmount (Name{primary key} Amount) and the another one is StockPrice(ID{Primary key with autogenerated} Name{foreign key with StockAmount table} Price) And then I store some data to StockAmount. -a 100 -b 200 -c 300 StockPrice -1 a 20000 -2 b 15000 -3 c 25000 And then I retrieve the data like this. Select StockAmount.NameStockAmount.QuantityStockPrice.Price from StockAmountStockPrice where StockAmount.Name='a' The result comes out a 100 20000 b 200 20000 c 300 20000 I want only one line like a 100 20000. Please solve my problem and reply to me. Thanks a lot for your help.

Sujeet Suman · Answer

Please once try below query: - StockAmount ( Name { primary key } Amount ) StockPrice ( ID { Primary key with autogenerated } Name { foreign key with StockAmount table } Price ) Select sa.Name sa.Quantity sp.Price from StockAmount sa Inner Join StockPrice sp ON sa.Name = sp.Name where StockAmount.Name = 'a'