₦airaland Forum

Dear everyone, please I need to select some values from a table(A), but those records must not be contained in another table(B). I.e. All records in A that are not in B. Thanks

Try using set notation for sql: union,minus or intersect will do that for you. I know these are supported on oracle. For this situation, minus will do.

U can use JOIN or write a subquery. ......... E.g. Using subqueries;
SELECT columnA,....,
FROM TableA
WHERE ( SELECT columnB, ......,
FROM TableB);

saintiyke: U can use JOIN or write a subquery. ......... E.g. Using subqueries;
SELECT columnA,....,
FROM TableA
WHERE ( SELECT columnB, ......,
FROM TableB);

. ....... Represents other columns u might want to select.

In using JOIN, u must know the primary key and the foreign key of each table

Many thanks to you all for your contribution. I have tried using Join before posting it on NL. I was not getting it right. Can you just help me post the query here. Thanks

try this if it will work. Select column1,column2,... From tableA Minus Select column1,column2,... From tableB;

I'm learning.

Listener10: try this if it will work. Select column1,column2,... From tableA Minus Select column1,column2,... From tableB;

where is the relationship between TableA and TableB ? I dont think it worths trying as u will surely get an error

saintiyke: where is the relationship between TableA and TableB ? I dont think it worths trying as u will surely get an error

guy,the op didnt state d relationship btw d two tables. We dont know d structure of the two tables.you can only write out the relationship btw two tables when u know their structures.the op only asked for d syntax and not d actual statement.he'll be d one to complete d statements since he's d only person that knows d structure of d tables.what i gave is just a clue.how do u expect me to know d relationship btw two tables when i dont know d primary key or d foreign keys of d tables

Big Star: Dear everyone, please I need to select some values from a table(A), but those records must not be contained in another table(B). I.e. All records in A that are not in B. Thanks

are you trying to select from table A only, the values not in table B
then you may want to use subqueries

SELECT * FROM tableA WHERE tableA.id not in (select id from tableB)

webdezzi: SELECT * FROM tableA WHERE tableA.id not in (select id from tableB)

Wow! Thanks so much. This code works like magic. @moderators, kindly provide a button for marking a post as resolved. Thanks everybody.

Big Star: Wow! Thanks so much. This code works like magic. @moderators, kindly provide a button for marking a post as resolved. Thanks everybody.

Simply modify the topic and add [Solved] at the beginning.