MySQL Forums
Forum List  »  Newbie

Re: Select over multiple Tables
Posted by: Horst Treu
Date: October 31, 2017 11:17AM

SELECT orders.*, orders_total.value, orders_total.class FROM `orders` LEFT JOIN orders_total ON orders.orders_id = orders_total.orders_id WHERE date_purchased BETWEEN '".$von."' AND '".$bis."'");


this works, thank you.

But..

is sends me 3 times the same result with every class from table2.

how i can use the 3 classes (ot_total,ot_total_netto,ot_tax) in one result?

Options: ReplyQuote


Subject
Written By
Posted
October 31, 2017 09:24AM
October 31, 2017 10:03AM
Re: Select over multiple Tables
October 31, 2017 11:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.