Multiple Queries For Odbc Import

[peterlaursen]

I'm sorry but I don't understand this.

Could you specify where you enter that query?/those queries?

What is the ODBCsource that you import from?

Could you paste in an example? or provide a screen-dump?

And what do you want to accomplish with that can't be accomplished by now?

[noblenull]

peterlaursen wrote on Sep 23 2005, 07:51 PM:

I'm sorry but I don't understand this.

Could you specify where you enter that query?/those queries?

What is the ODBCsource that you import from?

Could you paste in an example? or provide a screen-dump?

And what do you want to accomplish with that can't be accomplished by now?

[post=”7296″]<{POST_SNAPBACK}>[/post]

Say for example, I want to select a customer name based on order date.

I would do something like:

select name from customers where orderdate > '9/23/2005';

I then want to update ALL of the prices from my inventory table.

select model, price FROM inventory;

Currently, it is not possible to do both of these things in 1 job (as far as I know).

[Ritesh]

Yes, you are correct. You can import data from two results in one job session. You will need to have two job sessions.

I have written this in the TO-DO list of SQLyog but I cannot guarantee which version will have this feature.

[Author]

Posts