hi,
I am trying to have a input php/html file that contains drop down list from 2 different tables.
Table Name | Column1 | column2
customer | Cust_id | customer
Products | Prod_id |Item
I need to be able to select records from these table to insert in a third table (Orders)
here is my querry but I am not getting the right data.
SELECT Company
from customer
UNION
SELECT Item
from Products
also I tried :
SELECT COUNT(*) AS Rows
, Item
, Company
, Type
FROM test3
GROUP BY Item
ORDER BY Item
can someone help please?