Joining sysdevices table and sysusages table in sysbase

• opabid

  SSC Enthusiast

  Points: 153

  More actions

  May 14, 2008 at 2:15 am

  #91824

  Pls can someone help me with a script to join this two system tables in sybase

  sysdevices table and sysusages

  thanks

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  May 14, 2008 at 2:24 am

  #814975

  I haven't touched sybase for a while but I think it'd be something like:

  SELECT {columns}

  FROM sysusages, sysdevices

  WHERE sysusages.vstart >= sysdevices.low

  AND sysusages.vstart <= sysdevices.high

  I think :crazy:

  {edit: forgot the 's' on usages!}

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]