Help with 2 table SQL Query
I have a small problem with price lists in SQL.
I have one table with fields Item_num,item_cost,item_price
In another table I would like to apply special prices for specific Items in the main price list table. The structure of the 2nd table is
Account_num (Related to the customer account)
I would like to be able to execute an sql statement against both tables and return all items for a particular account number that are actively discounted and all other items from the standard price list (excluding the list prices of items that have discounts applied)
Can anyone help????????