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')
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'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.