Post reply

Query Help .NET

  • June 20, 2005 at 10:16 am

    #566792

    I have not set the Correlation on the table and the query yet.

    Dam again!

  • June 21, 2005 at 2:56 am

    #566966

    Well, with correlation I meant just that your query was not using your table

    And I didn't understand entirely your question... You mean that you want the company that charges the least, first in your resultset?

    ORDER BY Price ASC

    You could also add a percentage (to the resultset) that shows how much OVER the lowest price, the company sells for...

    Please specify a little bit more...

  • June 21, 2005 at 6:54 am

    #566999

     

    I would like to add a percentage to OR  subtract a percentage from THE RESULT based on the CompayID AND the ProdcutID.

     

    Thanks!

    Dam again!

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply