Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Traveler Vs. Country -- please help in framing query 1
- Thread starter Deadline
- Start date
-
1
- #2
tlbroadbent
MIS
The following query will return the list of all travelers in a country along with the manager name. You simply need to process the recordset in VB.
Select MANAGER, TRAVELER, COUNTRY
From TBL_TRAVELER t
Inner Join TBL_COUNTRY c
On t.Country=c.Country Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Select MANAGER, TRAVELER, COUNTRY
From TBL_TRAVELER t
Inner Join TBL_COUNTRY c
On t.Country=c.Country Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
- Status
Similar threads
- Locked
- Question
- Locked
- Question