Re: sel query

On Sun, 30 Oct 2005 01:36:04 -0700, shif wrote:

>HI
>i am having 2 tables pur_hd and pur_det, Pur_hd is having invoice_date and
>pur_det is having cost column, and common column purno is in both table for
>linking.How can i take the cost of max(invoice_date)from pur_det table using
>select stmt.
>thanks

Hi Shif,

Please post more information: exact table structure, as CREATE TABLE
statements that include all constraints and properties (irrelevant
columns may be omitted though); some sample data, as INSERT statements;
and expected results.

Check out www.aspfaq.com/5006 for some other useful advise on the best
way to ask questions in the newsgroups.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • ACWP and Actual Cost....
    ... columns in my Actual Cost column which don't equal my ACWP ... Only when I change the constraints to ASAP does the ... The way this project plan is laid out, ...
    (microsoft.public.project.standard_and_server)
  • Re: ACWP and Actual Cost....
    ... > columns in my Actual Cost column which don't equal my ACWP ... Only when I change the constraints to ASAP does the ... The way this project plan is laid out, ...
    (microsoft.public.project.standard_and_server)