I have the following tables: 1.) PRODUCT_INFORMATION: "ID", "CUST_ID", "DISTR_ID", "PROD_ID", "CNC_ID" 2.) CUSTOMERS: "ID", "CUSTOMER_NAME" 3.) DISTRIBUTORS: &qu ...

i'm trying to get the summerized date from join query using aggregate function count() and left join [code] select Catagories.FieldId,Catagories.BookField, BookTitles.FieldId as"btitle" from Catagories left join BookTitle ...

I have to create a marking system. One such table i.e the marking table contains student code and module 1 to module 24 that will contains the individual marks. The program has to check the student code against the actual information foun ...