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?