db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Varghese" <john.vargh...@kalzoom.com>
Subject Problem using Join
Date Mon, 02 Feb 2004 06:48:36 GMT
Hi,
 How to write this in Torque
---------------------------------------------------------------------------------------------------------
    select b.drawing_id from product a , drawing b where
        a.product_code = 'P001'
        and trim(b.drawing_code) = trim (a.drawing_code)
         and  b.product_id = a.product_id;
---------------------------------------------------------------------------------------------------------

I am interested in the trim part used in join.
Regards
John

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message