Access 2000, Access 2003, Access 2007 forms, Access 2007 functions, Access Database, Access Forms Database, Access Functions, Access reports, Binary data, CSV, Data structures, Database administration, Database Backup, Database connectivity, Database design, Database issues, Database management, Database migration, Database mirroring, Database servers, DB2 administration, DB2 Universal Database, DB2 Web Query, DBA, DELETE statement, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, Indexes, INSERT statement, IT careers, JDBC, JOIN statement, LOOP statement, Microsoft Access, Microsoft Access subforms, Microsoft Access tables, MySQL, MySQL Database, MySQL query, ODBC, QMF, Query optimization, SQL queries, Sybase, Timestamp, Triggers, UPDATE statement VIEW ALL TAGS
What is the difference between Outerjoin and Left outerjoin.
I have a table with the main fields being BU, ASSET, BOOK for any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the...