Sounds like a place I could get used to! ...that...

I drive past corn fields every day to work (and have at least 2 ethanol plants within 40 miles of my house... anyone like the smell of rotten corn?)... and...

I hear your complaints of your fuel costs. If the US were paying the fuel prices you all are paying, I'm scared to think of the inflation felt world-wide!

As...

I'll take a look at the FULL OUTER JOIN...

Here's the answer to Gail's question (not a small amount of stuff):

PRODBOM table:

CREATE TABLE [dbo].[PRODBOM](

[PRODID] [varchar](20) NOT NULL DEFAULT (''),

[LINENUM] [numeric](28, 12)...

That's what I get for trying to keep the thread simple...

In reality ItemID & BatchID aren't the link back to the main table, though it is the linking column between...

Perfect! Thanks!

RyanRandall (7/22/2008)

---

select t.ItemNo, a.qty, b.qty, c.qty from

(select ItemNo from TableA union select ItemNo from TableB union select ItemNo from TableC) t

left...

Thanks for the quick reply. I'll give the UNION a try.