Try to use set operator, that should solve your Qry1 and Qry2.
for the third qry try to join both the tables.
Thread: Help with SQL  |
|||||||||||||
|
Started 1 month, 3 weeks ago by cjmartin
I have the following:
Table A Table B
Pallet_No Pallet_No
Qty Qty
I need to return:
- All of the Pallet_No's from Table A that are not in Table B
- All of the Pallet_No's from Table B that are not in Table A
- All the Pallet_No's where there is a difference in Qty b/w Table A and Table B.
Thanks for your help.
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread: |
Top contributing authorsRelated threads on "Dev Shed Forums - Open Source web development":Related threads on other sites: |
||||||||||||
Thread profile page for "Help with SQL" on http://www.devshed.com.
This report page is a snippet summary view from a single thread "Help with SQL", located on the Message Board at http://www.devshed.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.