davidwoo
Posts: 53
|
| Posted: 05/25/2007, 12:25 AM |
|
Hi All,
How to use the CCDLookup with more than 1 table?
Thanks.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/25/2007, 1:29 AM |
|
Hi,
This may depend on what you need to do. I suspect that in some cases it is possible to specify 2 tables separated by commas like "table1, table2", while in most cases it should not be necessary to use CCDLookup with multiple tables but execute an SQL statement instead.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Benjamin Krajmalnik
|
| Posted: 05/25/2007, 10:25 AM |
|
CCDLookup("Table2.Field1", "Table1 inner join Table2 on Table2.Field3 =
Table1.Field2", "Table1.Field1 = " & somevalue, ConnectionObject)
Works fine.
|
|
|
|
|
