| # | Date | Forum | Type | Thread | Post |
|---|---|---|---|---|---|
| 2 | 27 Jun 2009 @ 10:12 PDT | Analytics | Reply | Generate errors for intersection of queries | Hello,I want to display all records in ABC which do not intersect the b,d in XYZ.What logic do I use ?very simple with one field, try thisselect A,b from ABC where b not in ( select d from XYZ)bye |
| 1 | 27 Jun 2009 @ 08:20 PDT | Analytics | Reply | what is best way to query huge table primary partitioned by date and indexed by id and date | Hello I work with Teradata in a company of telecommunication,Your query is ok, but we need know how many tables are joined in your query. For example I think this is correct;FROM IPSHARE.TMANNS_HER... |