Left join question

[#1]

HI guys,

I am doing the following join which works perfectly..

left join (SalesLines)

Load TxnID, TxnDate  Resident Sales;

It joins on TxnID.

Now i need to take all fields of Sales in Sales Lines so I wish to do something like this

left join (SalesLines)

Load TxnID, *  Resident Sales;

and it does not work.

Any suggestion?

[iktrayanov]

Try

left join (SalesLines)

Load  *  Resident Sales;

[#3]

I tried that but it did not work...it did not bring any data to SalesLines.

[#4]

Hi,

Have you checked there's not a single field name apart from TxnID and TxnDate that is common to both tables? That's usually the trap with this kind of "massive join".

You can also try:

join (SalesLines)

Load *  Resident Sales

where exists (TxnID)

;

The result may show what causes the issue.

Hope it helps.

[#5]

It gives error saying that "exists" field does not exist.

[#6]

Sorry, I had forgotten the parenthesis. Edited in previous post.

Where exists (TxnID)

Have you checked there's no other field named the same way between the 2 tables?

[MK_QSL]

Let us know the exact fields of both tables.... Hope you are not applying Where Exist in SQL Select load.

[#8]

it does not give any error but it did not any data from sales to salesline either.

[#9]

I am doing this

left join (SalesLines)

  Load *  Resident Sales

  where exists (TxnID);

[#10]

I am doing this.

left join (SalesLines)

  Load *  Resident Sales

  where exists (TxnID);