Where exist different connections

[Michiel_QV_Fan]

Hi,

Is it possible tu use where exist with different data sources.

For instance:

Specs:

A,

B,

from ..../...../......xls

Orders:

Product,

A,

Quantity

from {datasource} where exists A;

If not, any idea how limit Orders with where exists?

Thanks!

[Michiel_QV_Fan]

Thanks for your help.

I'm figuring out your script. Haven't got it working yet. It reads the temp table twice and not the RESIDENT table....

[Michiel_QV_Fan]

txBilling_temp:
LOAD
ACCTNUM,
AMTPAID,
BILL,
BILLREF,
DATE,
INVOICE,
isAccountInvoiced,
MEDNO,
ReDone;
SQL SELECT * FROM txBilling;

txBilling:
LOAD * RESIDENT txBilling_temp;

drop table txBilling_temp;

Results in nothing....

[Anonymous]

HI,

QV will auto concatenate if the two adjacent tables have the same columns. Place the word NOCONCATENATE between the two loads to stop this. You will then be able to drop your temp table withouth losing your resident table.

Also, looking at your exists issues.....you can always use left or inner join to overcome your problem. Join the two tables on your DATE field. so.....as a noddy script example.....

Load Date
SQL SELECT .......

left join

Load Date,
col2,
col3,
..............................

This would only give you dates in your second table for dates in your first. etc. etc.

Cheers.

Ad.