SQL Procedure Questions and Answers

Recent IT Questions

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

Why are naturl JOIN keywords not an option for producing a self-join?

Why are naturl JOIN keywords not an option for producing a self-join?

View Answer   |  Oct 7 2009  2:16 PM GMT
JOIN statement, SQL procedure
asked by Meganlh

  5 pts.

SQL proceedure to join header and detail file

I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

Answer Question   |  Nov 4 2008  5:48 PM GMT
AS/400, SQL, DB2
asked by AS400 - Ask the Expert

  395 pts.

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