How to write a Query for thisScenario in SQL Server???

Jan 1 2013 2:38 AM

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?

Answers (1)

Getting error: Ambiguous column name 'ecode'