Adodc Inner Join 
Author Message
 Adodc Inner Join

I putted in the Adodc RecordSource(adCmdUnknown) the line:

select * from employees inner join employee_education on employees.Employee_number=Employee_Education.Employee_number

but when i start the program, it shows only one record (i binded the first table only), like there is no othere records.
what should be the problem?

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!



Fri, 27 Feb 2004 07:21:14 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Adodc Inner join

2. SELECT . INNER JOIN--INNER JOIN

3. PRB: Left join behaves like a inner join.

4. Inner Join Question

5. !how VB update Table A INNER JOIN Table B, Set A.co=B.ID

6. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

7. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

8. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

9. How to execute a Inner Join between Tables on a DATASET

10. how VB update Table A INNER JOIN Table B, Set A.co=B.ID

11. INNER JOIN 2 TABLES

12. Why does this INNER JOIN not work?

 

 
Powered by phpBB® Forum Software