
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LEFT JOIN not working
Hello,
I have a very simple question.
I want to join two tables, where Table A I have my numerical data, and B I have the same dimensions plus another column.
Using a simple left join it is not working, the Column Factorized_Units results in 0.
I'm doing a very simple command such as:
Final:
LOAD * FROM
Table A
Left Join
LOAD * FROM
Table B
Why a simple left join doesn't works?
Thank you!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pretty hard to say since all you've included is a list of columns...
I'd suggest checking:
1) Data types match for each key field between the two tables. If they do not, they should be made to match
2) Values in B match to a value in A for all of the key fields
Something you could try is to remove the LEFT JOIN and just load the two tables individually. Then, select a value in the Factorized_Units field and see which other fields gray out entirely (all values are excluded) when they shouldn't.
