在mysql中选择两个独立的表[关闭]

Question

$results = $mysqli->query("SELECT product_name,price FROM herbs an WHERE product_code='$product_code' LIMIT 1");
    $obj = $results->fetch_object();

This is my code I want to get the two table form the database which is "herbs" and "fruits" and update my shopping cart.

How can I select two table product_name, price from two independent tables?

Answer 1

It sounds like you want to use either an inner join or an outer join.

http://en.wikipedia.org/wiki/Join_(SQL)

Or possibly a union:

http://en.wikipedia.org/wiki/Union_(SQL)#UNION_operator