Archives of the TeradataForum

Message Posted: Wed, 29 Jul 2009 @ 07:30:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

When I am running this query using Teradata SQL Assistant I am able to get 4 columns which I am expecting in the output, but when I am trying to execute the same query using bteq then I am getting all the row but only two columns, What is the reason and what is the possible solution for this?

     Locking row For access
     Select Distinct
      software_seq.part_id,
      description,
      site_id,
      reporting_app_name
     From    software_seq

      Inner join
       (
     Select  part_id
     From    software_seq
     Minus
     Select  vendor_part_id
     From    pkgname_master_t
       ) NewSoftware

      on

      software_seq.part_id = newsoftware.part_id;

Thanks,

Gautam Poddar

	<Prev	Next>		<<First	<Prev	Next>	Last>>