Category "inner-join"

What is wrong with this inner join sql query

I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the cou

Error: 'duplicate key value violates unique constraint' even when checking with 'where not in'

I get the error: 'duplicate key value violates unique constraint' even when checking if the primary key is already in the table in which I want to insert. I ha

Oracle DB SQL SELECT FROM a, b INNER JOIN c : is that possible?

I had a SQL SELECT dtl.ACCT_YM AS ACCT_YM, src.SRC_NAME AS SRC_NAME, ptnr.PTNR_NAME AS PTNR_NAME, info.P