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 Join using trim
Date Tue, 17 Feb 2004 06:43:36 GMT
Hi,
   I want to do a join on 2 tables as follows

----------------------------------------------------------------
    select vendor_email from vendor_master v, lot_master b
    where b.lot_id = 43
    and trim(v.vendor_code) = trim(b.vendor_code);
----------------------------------------------------------------

The vendor_code is of type varchar2(50)

Hoe to accomplish this in torque

Thanks
John V

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