One doubt on SQL command “Like”.

20 pts.
Tags:
AS400 - SQL Queries
SQL commands
 Hi One doubt on SQL command "Like". File 1 File Name:- A1 Filed(A1F):- 10 0  Zoned File 2 File Name:- A2 Filed(A2F):-  30 Character Please help me to search the data from file 1(A1) field data(A1F) value is present or not on file 2(A2) filed (A2F). I need to search multiple data from the pf 2, Ie, First records from the file 1 and find out all the matching data from file 2. Then 2nd record from the file 1 and find out all the matching data from file 2. and 3rd , 4the till EOF. Please help me to resolve Thanks Amal

Software/Hardware used:
Sql

Answer Wiki

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

Discuss This Question: 1  Reply

 
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
  • CharlieBrowne
    Select * from A1 
    Join A2
    on A1F like(&A2F%)

    41,430 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