Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Syntax to join 2 tables
Message
From
07/06/2005 09:30:15
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL Server Syntax to join 2 tables
Miscellaneous
Thread ID:
01020875
Message ID:
01020883
Views:
15
I used the syntax that you gave me but it returned 2 records instead of 1. Is there something that I am missing ? the following is the syntax I used
"SELECT * FROM CIVIL JOIN persons ON persons.pkeyident = civil.keyident AND (persons.per_type = 'D' or persons.per_type = 'C')"

Thanks Again !
Stephen J. Hunt
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform