Recent IT Questions

1 - 1 of 1
<<PREVIOUS 1 NEXT>>

Select from table where data row missing

I have a table with the main fields being BU, ASSET, BOOKfor any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the table...

View Answer   |  Oct 15 2007   9:34 PM GMT   |  asked by Jej1216
SELECT statement, Outer Join


1 - 1 of 1
<<PREVIOUS 1 NEXT>>