We are converting Access reports to impromptu reports. We dont have any access rights to modify tables or joins or catalogs. In access query there is left join. But when i select the two fields from corresponding folders which were designed by client in catalog its not joining by left join. Its joining by simple where condition. Is there any way to achieve this left join with out modifying joins and folders. Please reply ASAP
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Join Problems
- Thread starter cogjai
- Start date
I believe the only way you can do this is by editing the SQL (under the Query-Profile-SQL), which then causes extreme limitations in the ability to further modify the report.
lex
"Time flies like an arrow, but fruit flies like a banana."
lex
"Time flies like an arrow, but fruit flies like a banana."
- Status
Similar threads
- Locked
- Question
- Locked
- Question