Simple question about AS/400 query

5 pts.
Tags:
AS/400 Query
JOIN statement
Maybe for you that will be a stupid question, but I'm taking the first steps and I don't know what exactly I have to do in the "Specify how to join files" screen. If I put more joints in more rows it is how there was an "and" before every new row? I mean, all the rows are conditions that have to be satisfied togheter or every rows has no relationship with the row above? I hope I've been clear!
ASKED: July 29, 2008  9:18 AM
UPDATED: May 7, 2010  7:54 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

All the selections are treated like they have an and.

Regards,

Martin Gilbert.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Eamon60
    The first file listed in the query is the primary file. The Primary file being the first file read. It's more efficient to create relationships from the first file. The more relationships created the less effiicent the query. Especially when relationships are created between secondary and tertiary files. Hope this helps.
    75 pointsBadges:
    report
  • TomLiotta
    ...every rows has no relationship with the row above... If that's true, then it's not a valid JOIN specification. ...all the rows are conditions that have to be satisfied togheter... That is the case. All the rows are conditions that have to be satisfied. That is why AND works. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following