Member Avatar for Majestics

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 because: n/a
  • 1 Contributor
  • 2 Replies
  • 87 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Majestics
Member Avatar for Majestics 
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 ...

Member Avatar for Majestics

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.