sqldatabasems-accessentity-relationshiperd
How to show the same field value from another entity attributes
How can i show the same value of attribute from Item_Stock under entity PurchaseOrder and Warehouse ?
To be more specific, i need to do a calculation from warehouse that when Item_Stock is taken by PurchaseOrder then the Item_Stock value at Warehouse will be minus according to how many total quantity of the Purchase_Quantity.
Solution
By using a SQL query, the following should show which products that has the same "item_Stock" value on both PurchaseOrder table or Warehouse table.
select
p.product_id,
po.item_Stock as PurchaseOrder_item_Stock,
po.item_Stock as Warehouse_item_Stock,
from product p
join PurchaseOrder po on p.product_id = po.product_id
join Warehouse w on p.product_id = w.product_id
where po.item_Stock = w.item_Stock
the field's value is being shown side by side as different columns for each entity.
- Cascading Soft Delete
- ERROR: extra data after last expected column on postgresql
- Create login and logout rows from single row
- Add parameter within SQL query - Python
- How to Count & Group SQL Results into Custom Group Categories?
- How to SQL Filter for Timestamp Differences in Toad for Oracle?
- How to convert a Calculated Time Difference to Decimals in Toad for Oracle?
- How to find entries in a Column - where an adjacent column switches value, and then reverts back to the original value?
- SQL, How to convert VARCHAR to bigint?
- How to join two tables where the entries are listed as rows in one table and as columns in the other table?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- Get mySQL MONTH() to use leading zeros?
- Select only distinct values from two tables on pgadmin without getting all combinations
- Brand name whose amount is increasing every year
- Performance loss introducing lateral join in Postgres query
- Is it possible to create a procedure with ANALYZE table instruction?
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- How can i insert/ select into a table and delete copied records from original table?
- Synapse/ ADF - How to Truncate table if dynamic config column is True in pre-copy script
- Fastest way to determine if record exists
- Unrecognized column name that I define
- SEDE Data Query to find posts that have hidden comments added by me
- What is the most efficient way to count rows in a table in SQLite?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- Preg split multi SQL by semicolon in PHP
- Mysql Pivot View
- Is it good practice to have a column for each user and a row for each user in SQL table?
- How to filter Select option to ALL