Mkid price discount 1 100 2 2 150 0 3 100 0
<pre lang="SQL"> Mkid Name 1 Electronic 2 sports 3 Foods </pre>
select price, discount,(select name as 'name' from product where MKid=1) from market
SELECT price, discount, name FROM market LEFT JOIN product ON market.MKid = product.MKid
price discount name 100 2 electronics 150 0 sports 100 0 foods
select m.price, m.discount,p.name from market m inner join product p on m.MKid=p.MKid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)