Archives of the TeradataForum

Message Posted: Wed, 12 Dec 2007 @ 16:57:37 GMT

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

Hi,

Looking at your query it looks simple and straight, but at times simple queries will give us little trouble.

ponits to check

1) Check in the table B whether it contains records or not- Ideally it should have records.

2) Check for the Data types matching in bot the tables A and B, yet times we load fields as varchar in some tables in a intention not to disturb the original format of the data.

3) Convert the data to reflect the same format and data type before comparing, do a cast or trim(to get rid of any balnks or...).

Give a look on all the above points, Sure it works this time.

Good luck!!!

Thanks,

Vijay Kumar.R
WIPRO Technologies

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