SQL subquery question

2001-01-10 Thread Mary Fowler
Greetings, I have two tables. One (SECTIONS_DATA)is the main line item table of a budget. The second (ADJUSTMENTS)lists adjustments made to various line items of items in SECTIONS_DATA. The result set I am trying to get is one that can display the line items from SECTIONS_DATA with an adjustmen

RE: SQL subquery question

2001-01-11 Thread DeVoil, Nick
iness logic but conceivably you might need to join to ADJUSTMENTS twice in order to achieve that Nick -Original Message- From: Mary Fowler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 6:20 PM To: CF-Talk Subject: SQL subquery question Greetings, I have two tables. One (S