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