ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How do I duplicate Query/400 join type 3 with a join logical?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I duplicate Query/400 join type 3 with a join logical?

    I have a query that gives me the results I want using a join type 3 (unmatched records with primary file), and I want to create a join logical file that will give the same results.

    Basically, both files contain order data. I want to join on order number and only include the records from FILE A that do NOT have matching order number in FILE B. Is this even possible using a join logical file.

  • #2
    Re: How do I duplicate Query/400 join type 3 with a join logical?

    Join Logical file you say. No.
    How about creating a view instead.

    Select somefields
    from MYFile11
    exception Join MyFile22 on MyFile11.OrderNumber = MyFile22.OrderNumber


    If this is only going to be used in one thing, I would just use SQL in the program instead of making a view. This is rather simplistic for a view and a waste.

    Good Luck.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment


    • #3
      Re: How do I duplicate Query/400 join type 3 with a join logical?

      Yes, this is only for one thing/program. I will give that a try. Thanks for your reply!

      Comment


      • #4
        Re: How do I duplicate Query/400 join type 3 with a join logical?

        Worked great! Thanks again.

        Comment

        Working...
        X