SQL to fetch unmatched records.
Page 1 of 1
SQL to fetch unmatched records.
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.
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
Similar topics
» CL Question
» get the no.of records
» Total # of records in a file
» No of number records in a PF
» Find a String in a DBF records.
» get the no.of records
» Total # of records in a file
» No of number records in a PF
» Find a String in a DBF records.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|