Inner Join Not Working

[#1]

I am tryinig to join these two datsets.  The script runs with no errors, getting 90K records from the 1st data set and 100K records from the 2nd data set.  However, if I try to create a straight table or table box there are no records showing...just the column/field names.  Where's the data?

/*** GET DATA FROM ACCOUNT_BAN_TAXID ***/

Load *,
Account__c as AccountId;

SQL SELECT Account__c,
BAN__c,
Id,
Name,
Tax_ID__c
FROM Account_BAN_Tax_ID__c;

Inner Join

/*** GET DATA FROM ACCOUNT ***/
Load *,
Id as AccountId,
Name as AccountName;

SQL SELECT BANs__c,
Name,
Id,
Tax_id_2__c,
LastActivityDate,
Total_Sims__c
FROM Account;

drop Field Name, Id;

Thanks,   Dan

[swuehl · Accepted solution]

Dan, when you expand the star symbols, you will get

/*** GET DATA FROM ACCOUNT_BAN_TAXID ***/

Load

     Account__c,

     BAN__c,

    Id,

     Name,

     Tax_ID__c,

     Account__c as AccountId;

SQL SELECT Account__c,
BAN__c,
Id,
Name,
Tax_ID__c
FROM Account_BAN_Tax_ID__c;

Inner Join

/*** GET DATA FROM ACCOUNT ***/
Load

     BANs__c,
    Name,
     Id,
     Tax_id_2__c,
     LastActivityDate,
     Total_Sims__c,
     Id as AccountId,
     Name as AccountName;

SQL SELECT BANs__c,
Name,
Id,
Tax_id_2__c,
LastActivityDate,
Total_Sims__c
FROM Account;

drop Field Name, Id;

So your join is actually joining on three fields, Name, Id, and AccountId, right? Won't work, I believe, but don't know your data.

When you remove the join, the drop field statement will kick in at the end, so you get an association only by AccountId in that case.

Does this sound reasonable?

[#3]

This worked, swuhel.  By ensuring I was only joining on AccountId the join in the script worked.  Thanks to all who took the time to respond...much appreciated!