Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complex SQL Statement Help
Message
From
05/04/2005 13:16:48
Steven Dyke
Safran Seats USA
Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Complex SQL Statement Help
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01001581
Message ID:
01001581
Views:
71
I need help with an SQL statement. How do I get fields from both tables in the following statement:

Select name, badgeno from usrtbl Where usrid In (Select usrid From usrtbl2)

The usrtbl2 has a department field that I need in my query.
Next
Reply
Map
View

Click here to load this message in the networking platform