nope. it will not return 21. It will return all records from T_cands ( 14) and for ones having matching values it will retrieve those from the other table T_Options. so unless there's any one to many relationship output will only contain 14 records
My guess is in SSMS you're running query in different database or in different schema table.
Thanks for the reply. In fact I had a brainwave last night and found a solution:
sql_candidates = "SELECT T_cands.cand_id, T_Options.ox FROM T_Options RIGHT OUTER JOIN T_cands on T_cands.cand_id = T_Options.candid" Set rst_candidates = Server.CreateObject("ADODB.Recordset") rst_candidates.Open sql_candidates, db,1,3,1
If you get the recordset this way using the Open Method you only get 14 records. However:
sql_candidates = "SELECT T_cands.cand_id, T_Options.ox FROM T_Options RIGHT OUTER JOIN T_cands on T_cands.cand_id = T_Options.candid" Set rst_candidates=db.Execute(sql_candidates)
produces the 21 records required.
I haven't yet discovered why the Execute Method works and not the Open but it does!
I dont know much on application side so cant suggest more reg. Open and Execute. But if you execute query at db end it should always retrieve only 14 records
You could try making a procedure with above query and create it in your db. Then try calling the SP using open and execute and see if they work fine
right outer join not working.. help required
Posted - 05/06/2013 : 16:10:23
