That looks promising. Theres nothing in the way of multiple data source's in a Direct DBMS action though right?
----- Original Message ----- From: Ben Johansen To: Multiple recipients of list witango-talk Sent: Friday, November 08, 2002 11:27 AM Subject: RE: Witango-Talk: joins Well, It depends if the database supports it ;-) Your best bet is to create a View in the main database that is defined something like Select t1.*,t2.* from database1.table1 t1, database2.table2 t2 Then just use a standard select action in Witango Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Atrix Wolfe Sent: Friday, November 08, 2002 11:17 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: joins heya Ben, realized i was askin on the wrong list :P Does anyone know if theres a way to do a join between 2 tables in 2 different databases? ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
