Hi, I'd been trying to join a few tables & it just doesn't work propertly!
I've this main table of User and their Acces and on the other hand, I've a file with the password. So, i want to join every file with the password with the main table. It only works with the first file, the rest, it's like not exists.
Here's the code:
ACCESOS: LOAD * INLINE [ ACCESS, USERNAME ADMIN, ADMIN ADMIN, SA USER, SA USER, AA USER, BB USER, CC ];
LEFT JOIN (ACCESOS) Load USERNAME, [PASSWORD] FROM SA.xls (biff, embedded labels, table is [Sheet1$]);
LEFT JOIN (ACCESOS) Load USERNAME, [PASSWORD] FROM ADMIN.xls (biff, embedded labels, table is [Sheet1$]);
LEFT JOIN (ACCESOS) Load USERNAME, [PASSWORD] FROM BB.xls (biff, embedded labels, table is [Sheet1$]);
I don't know WHY if i'm writing (ACCESOS) don't join it, i really hope isn't something about left, right, outer (i'll be ashame!)
Thxs in advance for your help! i'm confident that's quite easy to resolve! 🙂
