i have two products , product one has 5 entries of date and product 2 has 4 entries. I want to select max date entries of both...

select max(entrydate) from products,products_information where  products_information.pno = products.pno

It return a single max date of one product....

Please Help ..............

select p.productname,pinfo.entrydate from products p,products_information 

pinfo where pinfo.entrydate = (select max(entrydate) from 

products,products_information where  products.pno = pinfo.pno) and cno=1 

and pinfo.pno = p.pno

Now I have updated the code, i just want pinfo.entrydate get new value on change of p.pno ...

Its Done........ I have solved the problem... Sorry for starting a new thread

problem was at line 5 , its product_information.pno rather then products.pno