It depends on your database to some extent.
If you're using Access the simplest solution would be to link the
emp_course table in PQR to emp_details in XYZ using the file/get external
data/link tables menu. You can write SQL statements specifying XYZ as the
datasource and reference the emp_course table that is linked.
If you're using SQL Server or need to maintain a migration path from Access
to SQL Server the SQL syntax is SELECT * FROM emp_details INNER JOIN
db_name.dbo.emp_course ON whatever.
I have found that to allow the same set of templates to be used for Access
and SQL server in this situation I had to specify a db_prefix variable
which was set to "db_name.dbo." in a SQL Server environment and to "" for
Access. The SQL syntax that would execute on both platforms was:
SELECT * FROM emp_details INNER JOIN #db_prefix#emp_course ON whatever
Hope this helps
Julian
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
