Use Star (*) with mysql inner join?
I have always done inner joins that look like this
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID=Customers.CustomerID;
Where you specify each row you want. I am currently working with a table
that has 50 rows however and I don't want to type all these SQL joins with
all the rows, is there a way to say "select * from Orders, then give me
Customers.CustomerName join on ...." instead of specifying every row from
the first table?
No comments:
Post a Comment