sql squery

Results 1 to 2 of 2

Thread: sql squery

  1. #1
    Join Date
    Dec 1969

    Default sql squery

    Hi<BR><BR>I am searching through a table of products and the result is produced when a value is equal or greater than the value entered.<BR><BR>However, the client now wishes for this to continue but on some products, to return information if the value associated with the product is more than half the entered value.<BR><BR>Is this feasible without producing another query/recordset as this would cause issues with the sorting and therefore how the results are viewed.<BR><BR>Thanks for any help<BR><BR>Carl

  2. #2
    Join Date
    Dec 1969

    Default RE: sql squery

    You don&#039;t give us much to work on, but I guess you can do something like<BR><BR>[pseudo code]<BR><BR>SELECT *<BR>FROM table<BR>WHERE (somevalue = entered value) OR (someproduct = &#039;true&#039; AND (somevalue/2) &#062; entered value)<BR><BR>if you need some more specific code you need to supply some more info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts