Amacım; test_cevap tablosundaki son 41 test_cevap_value değerini almak. Tabi "WHERE" içindeki user_id ve test_no şartlarını da sağlamak kaydıyla.
Aşağıdaki sql cümlesini yazıp çalıştırdığımda saçma sapan bir sonuç dönüyor.
Nasıl bir sql cümlesi yazmalıyım.
Şimdiden teşekkürler..
SELECT test_cevap.test_cevap_value FROM test_cevap, test_cevapcilar WHERE test_cevapcilar.user_id =1234 AND test_cevap.test_cevap_id = test_cevapcilar.test_cevap_id AND test_cevap.test_no =1 ORDER BY test_cevap.test_cevap_id DESC LIMIT 41test_cevap tablosu:

CREATE TABLE IF NOT EXISTS `test_cevap` ( `test_cevap_id` int(11) NOT NULL AUTO_INCREMENT, `test_soru_id` int(6) NOT NULL, `test_cevap_value` smallint(2) NOT NULL, `test_no` int(11) NOT NULL, PRIMARY KEY (`test_cevap_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ; -- -- Tablo döküm verisi `test_cevap` -- INSERT INTO `test_cevap` (`test_cevap_id`, `test_soru_id`, `test_cevap_value`, `test_no`) VALUES (1, 1, 4, 1), (2, 2, 3, 1), (3, 3, 2, 1), (4, 4, 4, 1), (5, 5, 3, 1), (6, 6, 2, 1), (7, 7, 4, 1), (8, 8, 4, 1), (9, 9, 1, 1), (10, 10, 4, 1), (11, 11, 5, 1), (12, 12, 3, 1), (13, 13, 4, 1), (14, 14, 1, 1), (15, 15, 5, 1), (16, 16, 4, 1), (17, 17, 3, 1), (18, 18, 2, 1), (19, 19, 5, 1), (20, 20, 2, 1), (21, 21, 2, 1), (22, 22, 3, 1), (23, 23, 4, 1), (24, 24, 5, 1), (25, 25, 4, 1), (26, 26, 4, 1), (27, 27, 3, 1), (28, 28, 2, 1), (29, 29, 1, 1), (30, 30, 5, 1), (31, 31, 4, 1), (32, 32, 2, 1), (33, 33, 2, 1), (34, 34, 4, 1), (35, 36, 3, 1), (36, 37, 1, 1), (37, 38, 4, 1), (38, 39, 5, 1), (39, 40, 4, 1), (40, 41, 2, 1), (41, 31, 4, 1), (42, 32, 2, 1), (43, 33, 2, 1), (44, 34, 4, 1), (45, 36, 3, 1), (46, 37, 1, 1), (47, 38, 4, 1), (48, 39, 5, 1), (49, 40, 4, 1), (50, 21, 2, 1), (51, 22, 3, 1), (52, 23, 4, 1), (53, 24, 5, 1), (54, 25, 4, 1), (55, 26, 4, 1), (56, 27, 3, 1), (57, 28, 2, 1), (58, 29, 1, 1), (59, 30, 5, 1), (60, 1, 4, 2), (61, 2, 5, 2), (62, 3, 1, 2), (63, 4, 5, 2), (64, 5, 3, 2), (65, 6, 3, 2), (66, 7, 2, 2), (67, 8, 1, 2), (68, 9, 3, 2), (69, 10, 2, 2), (70, 11, 4, 2), (71, 12, 5, 2), (72, 13, 3, 2), (73, 14, 3, 2), (74, 15, 1, 2), (75, 16, 5, 2), (76, 17, 2, 2), (77, 18, 3, 2), (78, 19, 3, 2), (79, 20, 4, 2), (80, 21, 4, 2), (81, 22, 3, 2), (82, 23, 4, 2), (83, 24, 2, 2), (84, 25, 5, 2), (85, 26, 3, 2), (86, 27, 4, 2);
test_cevapcilar tablosu:

CREATE TABLE IF NOT EXISTS `test_cevapcilar` ( `test_cevapcilar_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` varchar(20) NOT NULL, `test_cevap_id` int(11) NOT NULL, `test_no` int(3) NOT NULL, PRIMARY KEY (`test_cevapcilar_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ; -- -- Tablo döküm verisi `test_cevapcilar` -- INSERT INTO `test_cevapcilar` (`test_cevapcilar_id`, `user_id`, `test_cevap_id`, `test_no`) VALUES (1, '1234', 1, 1), (2, '1234', 2, 1), (3, '1234', 3, 1), (4, '1234', 4, 1), (5, '1234', 5, 1), (6, '1234', 6, 1), (7, '1234', 7, 1), (8, '1234', 8, 1), (9, '1234', 9, 1), (10, '1234', 10, 1), (11, '1234', 11, 1), (12, '1234', 12, 1), (13, '1234', 13, 1), (14, '1234', 14, 1), (15, '1234', 15, 1), (16, '1234', 16, 1), (17, '1234', 17, 1), (18, '1234', 18, 1), (19, '1234', 19, 1), (20, '1234', 20, 1), (21, '1234', 21, 1), (22, '1234', 22, 1), (23, '1234', 23, 1), (24, '1234', 24, 1), (25, '1234', 25, 1), (26, '1234', 26, 1), (27, '1234', 27, 1), (28, '1234', 28, 1), (29, '1234', 29, 1), (30, '1234', 30, 1), (31, '1234', 31, 1), (32, '1234', 32, 1), (33, '1234', 33, 1), (34, '1234', 34, 1), (35, '1234', 35, 1), (36, '1234', 36, 1), (37, '1234', 37, 1), (38, '1234', 38, 1), (39, '1234', 39, 1), (40, '1234', 40, 1), (41, '1234', 41, 1), (42, '1234', 42, 1), (43, '1234', 43, 1), (44, '1234', 44, 1), (45, '1234', 45, 1), (46, '1234', 46, 1), (47, '1234', 47, 1), (48, '1234', 48, 1), (49, '1234', 49, 1), (50, '1234', 50, 1), (51, '1234', 51, 1), (52, '1234', 52, 1), (53, '1234', 53, 1), (54, '1234', 54, 1), (55, '1234', 55, 1), (56, '1234', 56, 1), (57, '1234', 57, 1), (58, '1234', 58, 1), (59, '1234', 59, 1), (60, '1234', 60, 2), (61, '1234', 61, 2), (62, '1234', 62, 2), (63, '1234', 63, 2), (64, '1234', 64, 2), (65, '1234', 65, 2), (66, '1234', 66, 2), (67, '1234', 67, 2), (68, '1234', 68, 2), (69, '1234', 69, 2), (70, '1234', 70, 2), (71, '1234', 71, 2), (72, '1234', 72, 2), (73, '1234', 73, 2), (74, '1234', 74, 2), (75, '1234', 75, 2), (76, '1234', 76, 2), (77, '1234', 77, 2), (78, '1234', 78, 2), (79, '1234', 79, 2), (80, '1234', 80, 2), (81, '1234', 81, 2), (82, '1234', 82, 2), (83, '1234', 83, 2), (84, '1234', 84, 2), (85, '1234', 85, 2), (86, '1234', 86, 2);