Hello all. How can I join 2 tables. I have one table called orders and one called credits. Each table has an orderid field . I just want to make one table with all order id's from "orders" and "credits". My db does'nt support union.
what is the data relationship between oders and credit? one-to-one? one-to-many? many-to-many? your results will vary depending but here is the basic idea:
SELECT orders.*, credits.* FROM orders, credits WHERE orders.orderid = credits.orderid
