imohammad
چهارشنبه 06 خرداد 1394, 10:38 صبح
سلام
دوتا کوئری زیر یه نتیجه رو بر میگردونه
چه تفاوتی دارن؟
SELECT person.name, items.title, orders.qty, (items.price * orders.qty) AS price
FROM person, items, orders
WHERE orders.person_id = person.id AND orders.item_id = items.id
SELECT person.name, items.title, orders.qty, (items.price * orders.qty) AS price
FROM person INNER JOIN (items INNER JOIN orders ON items.ID=orders.item_id) ON person.ID=orders.person_id;
دوتا کوئری زیر یه نتیجه رو بر میگردونه
چه تفاوتی دارن؟
SELECT person.name, items.title, orders.qty, (items.price * orders.qty) AS price
FROM person, items, orders
WHERE orders.person_id = person.id AND orders.item_id = items.id
SELECT person.name, items.title, orders.qty, (items.price * orders.qty) AS price
FROM person INNER JOIN (items INNER JOIN orders ON items.ID=orders.item_id) ON person.ID=orders.person_id;