SQL help?

Database
Enthusiast

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.
3 REPLIES

Re: SQL help?

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..............
Senior Apprentice

Re: SQL help?

@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
Teradata Employee

Re: SQL help?

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