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 Mike Lewis 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. charlieit3

    Newbie Query Question...

    That worked Robert!!! THANK YOU!!!
  2. charlieit3

    Newbie Query Question...

    Thanks Dan, but that did not work. It says "syntax error" and in the error it shows the query like this: SYNTAX ERROR: SELECT * FROM INV_MSTR WHERE PART = 'Widget1' and PARENT = ('aa09128'<<???>>, 'aa8643', 'ah9634')
  3. charlieit3

    Newbie Query Question...

    I have table called "INV_MSTR" and in it a column of data called "PART" and another called "PARENT". Each has thousands of rows. I need to find if specific PARENT items have the PART "Widget1". So I wrote a query: SELECT * FROM "INV_MSTR" WHERE PART = 'Widget1' and PARENT = ('aa09128'...

Part and Inventory Search

Back
Top