Re: Fw: Three Tables. Please help

2002-10-04 Thread Michael T. Babcock
William Martell wrote: >rice and on hand quantity from these three tables. Each part number is >the same in all three tables. The other fields are different. I would like >to display each tables data sorted by item number. I am having trouble with >my select statement. > > SQL: select * from

Fw: Three Tables. Please help

2002-10-04 Thread William Martell
Pass Filter: sql,query Hello All, I have three tables in my database t1, t2, and t3. Each table has records that are the same or similar. I am trying to SELECT part number, part description, location, part cost, sell price and on hand quantity from these three tables. Each part number is the