Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting fields based on another field in the same record
Message
From
10/09/2004 13:41:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Selecting fields based on another field in the same record
Miscellaneous
Thread ID:
00941126
Message ID:
00941126
Views:
81
Hello,
I have a table like following:
CODE|IDUSE    |
---------------
A   |FAXA     |
V   |FAXB     |
A   |FAXC     |
---------------
What I want is to run a select statement on this table that finds when the IDUSE matches FAX(which I will be supplying through code)+CODE (so the only one that would correctly show is FAXA). Sorry if I didn't explain this very well... but any help would be greatly appreciated. Thanks!!

MAC
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform