sql query

Pehape

there is a command in sql, to get records which on Table A but none on table B ?
A | B
1 7
2 1
3 4

get 2,3.., can't use <> for some reasons..

thanks

ClarkF1

Could you make the question easier to understand. I'm not sure what you want

I understand that you want the values in A that aren't in B, it's the "can't use <>" bit I don't understand.

What query are you using at the moment? Can we see some code?

Pehape

oh, that's nothing..., i don't use the query right now...
i just want to know if there are a keywords or command with the function like i mentioned above..?

NogDog

SELECT * FROM table_a WHERE some_column NOT IN (SELECT some_column FROM table_b)

(Note: if using MySQL, requires version >= 4.1.)

Pehape

thank you,
i still haven't got my result...
e.g
book borrowed-> code->01,02,03 //(borrow table)
book return -> code->01,03 //(return table)
i want to get 02 since it's not returned (the number which is not in book return column)

the table :
borrow table
id1 -mem_id -code
1 - -  m1  - -   01
1 - -  m1  - -  02
1 - -  m1  - -  03
return table
id3  -id1 - code
3       1       01
3       1       03
 // id1 on both table as borrow_id // mem_id on b.table is member id // id3 is other id...

so far i tried many queries, i got weird results as they compare it 'like' record by record instead of just 'collect the data on both table and see what code absent on the other table
. using my wrong query , i will get code column -> 03,02,02,01
this because 03 is compared with 01 --> true (say it's not same or not in)
then 02 is compared with 01--> true , next 02 is compared with 03 --> true
last 01 is compared with 03 -->true...
seem they compared borrow.code with all return.code one by one...
, sorry if i don't get you understand with my problm above... ,
please help me, thank you...

Pehape

still waiting for some helps...

stiduck

See if this helps you...

(SELECT Field A
FROM Table A)
EXCEPT
(SELECT Field B
FROM Table B)

Pehape

i can't use except. mysql v 4.0..
i don't know if except is exist..