PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SQL to fetch unmatched records.

Go down

SQL to fetch unmatched records. Empty SQL to fetch unmatched records.

Post  razuk_r Thu Dec 03, 2009 1:59 am

Hi,

I have a requirement in SQL. Please refer below.

1: SELECT WAREHOUSE FROM Table1 WHERE State <> '00'
Result : Warehouse --> J01, J03, J05, J07

2: SELECT Item Warehouse FROM Table2 WHERE PROD= '00142'
Result:
Item Warehouse
00142 J08
00142 J01
00142 J06
00142 J12

Requirement: Need to fetch warehouse from table 1 except the warehouse exists in Table 2. At last the result should be like below
00142 J03
00142 J05
00142 J07

Please advice me to get the result.

razuk_r

Posts : 65
Join date : 2009-07-31
Location : Chennai

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum