Select dl.area, dl.name as location, si.id, si.name as item_ref, ssi.Updated_at,ssi.count From data_location as dl inner join stk_stocktake_header ssh on dl.id = ssh.location_id inner join stk_stocktake_item ssi on ssi.stocktake_header_id = ssh.id inner join stk_item as si on si.id = ssi.stk_item_id inner join stk_product as sp on si.stk_product_id = sp.id inner join stk_stock_ref as ssr on sp.stk_stock_ref_id = ssr.id Where dl.area in ('Area 1 Scotland') and dl.name in ('Callander - 030') and si.id in (11391,11392) order by si.id,ssi.Updated_at desc
|How to set up data replication from SQL Server to MySQL?||5||39|
|How to return more than 1 value from a store procedure||21||37|
|Linking a DMV to a database id/sql text in SQL server 2008||8||46|
|How to send multiple emails at the same time in PHP||12||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!