Sql query

Question

I Have Two tables item_master and item_detail

the primary key Of the item_master .Item_id As the foreign key of item_detail table

In item_detail Contains A column barcode how to get Item_name From Item_master

Where Item_detail barcode not repeated one

Upendra Pratap Shahi · Answer

Try this- SELECT IM . Item_name FROM [Item_Master] IM INNER JOIN ( SELECT DISTINCT ID . Item_ID FROM [Item_Detail] ID INNER JOIN ( SELECT [Bar_Code] FROM [Item_Detail] GROUP BY [Bar_Code] HAVING COUNT ( [Bar_Code] ) 1 ) Temp ON ID . [Bar_Code] = Temp . [Bar_Code] ) Result ON IM . [Item_ID] = Result . Item_ID ;

Manas Mohapatra · Answer

Try with below query: SELECT IM. Item_name FROM [Item_Master] IM INNER JOIN (SELECT DISTINCT ID1.Item_ID FROM [Item_Detail] ID1 INNER JOIN ( SELECT [Bar_Code] FROM [Item_Detail] GROUP BY [Bar_Code] HAVING COUNT([Bar_Code]) ON ID1.[Bar_Code] = Temp.[Bar_Code]) Result ON IM.[Item_ID] = Result.Item_ID;

Navaz · Answer

ID AS ITEM_DETAIL AND IM AS ITEM MASTER

Raja T · Answer

Hi Try like select top 1 Item_id Item_name from item_master as t1 inner join Item_detail as t2 ON t1.Item_id=t2.Item_id where Item_detail.A='barcode' or share to me your table structure with records also

Manas Mohapatra · Answer

What is your question here.