Hello, I'm use MaxDB Version: '7.5.00.05 Build 005-121-054-885' Windows 2000(WIN32) I have problem
I use table test_a, test_b, test_c, test_d and view view_d. execute query I have result 1 record "3 1 1 1" , no I waiting 4 record , why I testing this query on oracle, oracle return 4 record . my query select b.* , C.* from test_a a , TEST_B b , VIEW_D C where a.id = b.id AND b.IDX = C.IDX (+) my tables and view create table test_a ( id int NOT NULL ) create table test_b ( id int NOT nULL, IDX int ) create table test_C ( ID int NOT nULL ) create table test_D ( IDX int NOT nULL, ID int NOT nULL ) insert test_a (id) values ( 1) insert test_a (id) values ( 2) insert test_a (id) values ( 3) insert test_B (id, IDX) values ( 1, NULL) insert test_B (id, IDX) values ( 2, NULL) insert test_B (id, IDX) values ( 3, NULL) insert test_B (id, IDX) values ( 3, 1) insert test_C(ID) values (1) insert test_C(ID) values (2) insert test_D(IDX, ID) values (1, 1) insert test_D(IDX, ID) values (2, 2) create view VIEW_D AS select b.ID, B.IDX from test_C A, test_D b WHERE A.ID = B.ID -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
