Archives of the TeradataForum
Message Posted: Wed, 29 Jul 2009 @ 07:30:27 GMT
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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|