high all,
i have two tables, a and b, and i want all records from table b that are not in table a...i tried all kinds of join , left,right full ... but all results were apparently *wrong*. i even tried "select b.* from a,b where a.x!=b.x" but: nothing...what am i doing wrong or is mysql inable to perform such stuff?
THX in advance
.neorex uptick
i have two tables, a and b, and i want all records from table b that are not in table a...i tried all kinds of join , left,right full ... but all results were apparently *wrong*. i even tried "select b.* from a,b where a.x!=b.x" but: nothing...what am i doing wrong or is mysql inable to perform such stuff?
THX in advance
.neorex uptick