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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-23 : 07:41:48
|
| Rick writes "I have for tables, Migrant table, Interdiction table, Val_Disposition table, Val_Country table. Table structures are as follows: Migrant Interdiction Val_Disposition Val_Country Migrant_ID (PK) Migrant_ID Disposition_Code (PK) Country_Code (PK)Family_ID Interdiction_Date Description Country_NameHead_Of_Family Interview_Date Comment_RequiredLast_Name APSO_NameFirst_Name Disposition_CodeMiddle_NameDate_Of_BirthCountry_CodeCity_Of-Origin Here’s what I need to extract: First_Name, Last_Name, Middle_Name, Date_Of_Birth, Country_Name, City_Of_Origin, LAST Interdiction_Date, Disposition, APSO_Name. Note: The interdiction table has multiple entries and what I need is the most current interdiction_Date with associated data. Any help is appreciated!" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-23 : 07:50:24
|
| Use MAX function.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
|
|
tables