... these tables ? OR are c1.AL_NO,c2.BR_NO, c3_MH_NO primary Keys ? Hi Villian, These are not primary index. I have created another index for These vars. alacak table. CREATE TABLE `alacak` ( `AID` INT(11) NOT NULL AUTO_INCREMENT, `AL_NO` INT(11) NULL ...