0

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 ..............

Edited by Majestics: n/a

1
Contributor
2
Replies
3
Views
6 Years
Discussion Span
Last Post by Majestics
0
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 ...

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.