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