Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mazdak
Yak Posting Veteran
63 Posts |
 Posted - 2006-12-03 : 03:26:31
|
| I have two table which second one is a Log table for first one and only has one extra field than first one (LogId field which is auto incremental bigint). I name them tbCustomer and tbCustomerLog. I need a query which get last row in both tables for each Customer and a field in both tables named StateId are not equal. I hope I'm clear about my problem.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-03 : 05:21:33
|
| Post some DDL and we might be able to help.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Problem in joinig two table....