CREATE PROCEDURE Sp_Select_area ( `name` VARCHAR(300) ) BEGIN SELECT areas.`name` FROM areas JOIN cities ON areas.cityid_fk=cities.id ORDER BY areas.`name` END;
create procedure select_area() begin select areas.Name from (( areas a JOIN city c ON a.cityid_pk = c.id) JOIN table3 on a.cityid_pk = table3.id and c.id=table3.id) ; end |
SELECT t1.name AS area, t2.name AS city FROM areas AS t1 JOIN city AS t2 ON t2.id = t1.cityid_pk;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)