[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference 7.286::visualc

Title:Microsoft Visual C/C++
Moderator:PLUGH::needle
Created:Tue Mar 16 1993
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1121
Total number of notes:4385

1086.0. "Should I use INNER JOIN or sub-query for ODBC" by KELVIN::KOU () Mon Feb 10 1997 16:37

    In the MS Access software, INNER JOIN and OUTER JOIN are use
    extensively in the SQL statement for query. However, when looking at
    Oracle data base, inner join and outer join are usually done with
    nested sub-query. My question is that which SQL syntax will work nicely
    with both data base using ODBC. Since the ODBC driver probably pass
    thru the SQL statement. Is there any advantage to either approaches ?
    
    The MS approach seem to allow better organization with CRecordset but
    it is difficult to read (at least from my view point). Any comment ?
    
    Mike
T.RTitleUserPersonal
Name		DateLines