Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Correct statement
Message
From
30/06/2006 13:03:55
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Correct statement
Miscellaneous
Thread ID:
01133122
Message ID:
01133122
Views:
55
Hi all,
I want to extract some names from a table 'x' with a 'where' clause, but only if the names are present in another table 'y'. For example: select name, surname from x where dimessa=0 .and.... (when the name and surname is present in the y table) into cursor mycursor.
Any idea about the correct statement sql?
Thanx in advance.
Next
Reply
Map
View

Click here to load this message in the networking platform