Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
SQL Expression for Referential Integrity
Whoops! ih should be s in this query. Sorry!!! -
Different Results based on placement of condition in query. Why?
I have two (basically similar) queries. The two return different results because of where I have placed the filter for a12.item_nbr = 'm015900706'. I don't understand why this changed the results. Can someone explain. The first query is as follows: select a12.ITEM_NBR ITEM_NBR... -
SQL Expression for Referential Integrity
I have been executing the following SQL expression to check for referential integrity. However, I am confused about the results I get back. select count(*) from ( select b.shop_order, b.so_time_stamp from inventory_history b where not exists (select * from shop_order s where...
