re: Fw: Three Tables

2002-10-04 Thread Egor Egorov
William, Thursday, October 03, 2002, 10:14:04 AM, you wrote: I have three tables in my database t1, t2, and t3. Each table has records that are the same or similar. I WM am trying to SELECT part number, part description, location, part cost, sell price and on hand quantity from these three

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

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 t1,

Fw: Three Tables

2002-10-03 Thread William Martell
Pass Filter: sql,query - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 1:48 AM Subject: Three Tables Hello All, I have three tables in my database t1, t2, and t3. Each table has records that are