All Forums Database
vamsi_142 17 posts Joined 03/11
09 Jun 2011
SQL help?

an employee changed his address from 'address1' to 'address2' .
i want to see both details of that employee from this time period to the last .
write a query?

Thanks&Regards,
Vamsi.

gu.rashmi13 1 post Joined 06/11
11 Jun 2011

I created a query using Teradata SQL Assistant.

Sel * from table1 (one dbase),table2(another dbase)

I get error as something missing between 2 tables. how do I fix this problem? please help..............

dnoeth 4628 posts Joined 11/04
13 Jun 2011

@Vamsi
Without any additional information my guess would be:
SELECT something FROM my_Crystal_Ball

@Rashmi
Could you also provide some more information like the actual query and error message?

Dieter

Dieter

Adeel Chaudhry 773 posts Joined 04/08
13 Jun 2011

@Vamsi .... is the table historized? Just as D said .... more information can be helpful :)

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.