Re: minus operation

2003-11-04 Thread Nitin
pe it helps Nitin - Original Message - From: "fab" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 1:58 PM Subject: minus operation > Hi to all, > > My question is rather about sql langage than mysql. > > Here it is: i have

minus operation

2003-11-04 Thread fab
Hi to all, My question is rather about sql langage than mysql. Here it is: i have 2 tables (A and B) with the same structure (4 fields called f1,f2,f3,f4). Table A counts x records and table B counts y records (and x <> y). Then, table A has records that do not belong to table B and table B has