Hello, I would like to compare two tables (of the same name) in two separate database files. I could conceivably change the situation such that I have 2 tables within the same database but different names.
My table definition is: CREATE TABLE (SchoolId INTEGER, SchoolName TEXT, EnrollmentCount INTEGER); I essentially want to generate a new database file that will output the difference in EnrollmentCount for each SchoolName. It is possible that some rows will be missing in either of the databases, and in that case I still want to print the row. I'm a bit new to SQLite so I don't know exactly how to syntactically compare two databases and of course, there is the SQL of the comparison (also which I'm new to) but I think I'll be able to figure that part out. I hope I've explained my question is detail. Would love your help and suggestions.
