Hi,
I want to join 2 tables and filter the data according to some rules.
I already have the sql statement for this operation from my colleague.
So, is there anyway I can directly use this sql statement to join and filter the data from these 2 tables?
or do I have to use tMap to put in the conditions?
Please reply ASAP..
Thank You.
Kyaw Lwin Phyo
As you say, your SQL is returning a single column only (the concated value of YearWeek-Start DateEnd Date) but the schema for the component has the standard columns from the table. Change the schema to match the results of the query. That is why there is a warning icon against the component.
Hi, I want to join 2 tables and filter the data according to some rules. I already have the sql statement for this operation from my colleague. So, is there anyway I can directly use this sql statement to join and filter the data from these 2 tables? or do I have to use tMap to put in the conditions? Please reply ASAP.. Thank You. Kyaw Lwin Phyo
SQL application is also prone to corruption like an other application. It may get corrupted or damaged due to various reasons. SQL become damaged due to virus attck, power failure or due to improper shut down. When SQL database become corrupted it becomes impossible for SQL user to make join statement. It needs
My SQL repair
