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

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

SQL to fetch unmatched records.

View previous topic View next topic Go down

SQL to fetch unmatched records.

Post  razuk_r on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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