Multiple Tables From Query Method

This topic is empty.

Viewing 4 reply threads

Author

Posts
- April 15, 2004 at 2:30 pm #8398
  
  mbrown
  Member
  
  When doing an ODBC import is there a way to get the results of more than one query? When I select “Copy table(s) from the data source” I get the option to select multiple tables. When I select “Use a query to select the data to transfer” I only get the results from the first query I type in the window.
  
  For example if I enter this in the query window:
  
  Code:
  
  select * from table1 where field1 = 'a';
  select * from table2 where field1 = 'b';
  
  It will return one table called “Result” that has the results of the first query only.
  
  Is there a way to get both of the queries to execute?
- April 16, 2004 at 8:01 am #15690
  
  Néo
  Member
  
  Well, I was about to ask the same question !
  
  Additionally, if there where any feature to schedule this import, my replication problems would be totally rid off.
  
  C'mon guys ! you're just so close to the ultimate replication solution !
- April 16, 2004 at 4:37 pm #15691
  
  mbrown
  Member
  
  a point of clarification:
  
  it executes all of the statements, but only returns the first resultset.
  
  for example:
  
  Code:
  
  declare @field int;
  set @field = 'value';
  select * from table1 where field1 = @field;
  select * from table2 where field1 = @field;
  
  it will declare the variable and set it equal to the value and excute the queries, but only the results from table1 will be returned.
- April 16, 2004 at 11:44 pm #15692
  
  Shadow
  Member
  
  Neo: scheduling ODBC import is planned for SQLyog MAX.
- April 25, 2004 at 1:16 am #15693
  
  Ritesh
  Member
  
  mbrown wrote on Apr 15 2004, 02:30 PM:
  
  When doing an ODBC import is there a way to get the results of more than one query? When I select “Copy table(s) from the data source” I get the option to select multiple tables. When I select “Use a query to select the data to transfer” I only get the results from the first query I type in the window.
  
  For example if I enter this in the query window:
  
  Code:
  
  select * from table1 where field1 = 'a';
  select * from table2 where field1 = 'b';
  
  It will return one table called “Result” that has the results of the first query only.
  
  Is there a way to get both of the queries to execute?
  
  SQLyog imports data from the first query only.
  
  This is a nice feature request. I have forwarded it to my development team. Thanks for the suggestion 😀
Author

Posts