+ Reply to Thread
Results 1 to 1 of 1

Adding Criteria To Query With 4 Tables Outer Joined

  1. #1
    Registered User
    Join Date
    12-27-2007
    Posts
    1

    Adding Criteria To Query With 4 Tables Outer Joined

    Hi. I have a problem in MsQuery with adding where-clause to sql (query from Progress database) where is 4 tables joined together with outer join. I managed to add where-clause to query where is three tables joined together with outer join simply just adding where clause to the end of sql-clause after outer join clauses.

    Is it possible to add where clause to clause where is four tables outer joined together ? Here is example of my code to which I would like to add that where-clause:

    Please Login or Register  to view this content.
    I tried to add below where-clause at the end of the code but it didn't work in this four table outer join case but like I told earlier, it worked when I deleted one table from join and there was only three tables that was outer joined.
    Please Login or Register  to view this content.
    Any ideas what I could try ?

    - SatuMaarit
    Last edited by SatuMaarit; 12-27-2007 at 05:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1