alidabiri

hi, i have 2 tables: CUST and ORDERS CUST contains cust_num, cust_name, cust_phone ORDERS contains cust_num, order_date, order_amt i want to list all the cust_names and their last order date and amount how would i code this? thanks.

this is what i use with vb and oracle 10g: [code] strCon = "Driver={Microsoft ODBC for Oracle}; " & _ "CONNECTSTRING=(DESCRIPTION=" & _ "(ADDRESS=(PROTOCOL=TCP)" & _ "(HOST=111.222.333.18)(PORT=1521))" & _ "(CONNECT_DATA=(SERVICE_NAME=mydata))); uid=user_id;pwd=your_psw;" Dim oCon oCon.Open strCon [/code]