Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 tables like metadata1 , metadata2 which is having same columns
Ex:
contract no, submission date, dateflag,source,creation date from Metadata1 table
Join
Contract no, submission date,dateflag,source,creation date from metadata2 table
Where dateflag =0 and submission date
So how this 2 tables are getting join based on this where condition ot with default join out. Can one please help me on this.
Because these are additional rows, you should be using Concatenate instead of Join.
MyTable:
Load contract no, submission date, dateflag,source,creation date from Metadata1...
Concatenate (MyTable)
Load contract no, submission date, dateflag,source,creation date from metadata2...
-Rob
Because these are additional rows, you should be using Concatenate instead of Join.
MyTable:
Load contract no, submission date, dateflag,source,creation date from Metadata1...
Concatenate (MyTable)
Load contract no, submission date, dateflag,source,creation date from metadata2...
-Rob