Results 1 to 3 of 3

Thread: [RESOLVED] select statement 2 tables

Threaded View

  1. May 2nd, 2007, 12:32 AM #1
    basti42
    basti42 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    Resolved [RESOLVED] select statement 2 tables

    SELECT avg(tblData.MV), tblStandard.MV_MIN FROM tblData, tblStandard WHERE tblData.COMPOUND_NO='123'

    i've got this error:
    "you try to execute a query does not include the specified expression 'MV_MIN
    as part of an aggregate function.'"

    above code would select/compute the average of tblData.MV
    and list tblStandard.MV_MIN, when i try to remove avg() and remain the tblData.MV no error found.

    any idea?


    tnx
    Last edited by Hack; May 2nd, 2007 at 05:51 AM. Reason: Added RESOLVED to thread title and green resolved checkmark
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width