I have 4 tables:
when inserting a record, will use the uniq location_id , product_id to insert into 2 tables: sale and move
--the requirement is that select a product_name and location_id to search all related records in the database.
--and then can select an individual record to update it
issue, i can get 1 more sale_id and move_id when joining these tables, it is hard to pick the record to update.( we are using .net at fron_end)
select * from sale,product,location,move