hi,
iam having three tables as shown below
table 1 table 2 table 3
column1 id column1 cust_id column1 cat_id
column2 cust_name column2 cat_id column2 cat_name
column3 cust_id column3 training
column4 posted_date
iam using the following query
Select A.id,A.cust_name,B.training from table1 A,table2 B,table3 C WHERE A.ID = B.cust_id AND B.cat_id = C.cat_id AND B.cat_id = 1 ORDER BY posted_date
for conditions as shown below iam getting multiple rows containing cust_name as same
1 test 1 2/4/2008 1 2 tr1 2 catname
1 2 tr2
i want to get cust_name as distinct and retrieve the training details correspondind to cust_name also