I have two tables as follows..
and the data in these tables is as follows
I want to write a query to display DrugName Instead of FKDrugId in Stock_Master Table.
can anyone help?
How to write a Query for thisScenario in SQL Server???
Hi,
I have two tables as follows..
and the data in these tables is as follows
I want to write a query to display DrugName Instead of FKDrugId in Stock_Master Table.
can anyone help?
I have two tables as follows..
and the data in these tables is as follows
I want to write a query to display DrugName Instead of FKDrugId in Stock_Master Table.
can anyone help?
Blocked AccountPosted Jan 1, 2013, 4:09 AM
Try this query to get the output as you want.
SELECT PKStockId,DM.DrugName,TotalQuantityOnHand FROM Stock_Master SM,Drug_Master DM
WHERE SM.FKDrugId = DM.PKDrugId