Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. manolito

    other tablesin the where clause of an Update/Delete..

    swampBoogie, maybe you missed the previous postings, the problem is Oracle-SQL, therefore SELECT FROM.. is the only way to go.
  2. manolito

    other tablesin the where clause of an Update/Delete..

    Hi there, I am assuming that the tables can be joined via id AND name. Try this: update table_b set (other_col_a, other_col_b, other_col_c) = (select other_col_a, other_col_b, other_col_c from table_a where table_a.id = table_b.id and table_a.name =...
  3. manolito

    Replacing NULL's in results

    First my recommendations for the future so that you don't run into this problem again: R1. Create new field UNIT_PRICE in the TRANSACTIONS table. R2. Create new field TRX_DATE in TRANSACTIONS table... so that price variations over time can be captured. This is unsolicited advise... but hey...
  4. manolito

    Does Data Mining Do This?

    There are two things that you need to do in order to perform meaningful analysis: 1. Plot sales per month per product 2. Get promotional/marketing program history, again per month per product. Collect all information that you can... what type of a discount was offered, for how long, etc. Label...

Part and Inventory Search

Back
Top