stored procedure to return data from multiple tables

Question

I have two tables

Property and Photo

Photo table has PropertyId FK column which assigning to Property table.

I have stored procedure which returns data from property table, now I want to modify this st. procedure to return photos data together with property data in a single st. procedure query. How to do this?

CREATE PROCEDURE GetAllData
AS
SELECT * 
FROM dbo.Property
GO

Read on [`JOIN`.](https://technet.microsoft.com/en-us/library/ms191472(v=sql.105).aspx) — Felix Pamittan, Aug 03 '15 at 11:30
possible duplicate of [How can an SQL query return data from multiple tables](http://stackoverflow.com/questions/12475850/how-can-an-sql-query-return-data-from-multiple-tables) — Tab Alleman, Aug 03 '15 at 13:05

score 0 · Answer 1 · edited May 23 '17 at 11:58

0

You join the 2 tables by an Id column.

CREATE PROCEDURE GetAllData

AS

SELECT * FROM dbo.Property prop
INNER JOIN dbo.Photo photo ON prop.PropertyId = photo.PropertyId

Another post about JOIN

edited May 23 '17 at 11:58

Community

1
1

answered Aug 03 '15 at 11:33

shammelburg

6,974
7
26
34

score 0 · Answer 2 · edited Aug 03 '15 at 11:41

0

Try below code.

CREATE PROCEDURE GetAllData
AS
SELECT * 
FROM dbo.Photo p inner join dbo.Property pr
on p.PropertyId = pr.PropertyId 
GO

edited Aug 03 '15 at 11:41

Felix Pamittan

31,544
7
41
67

answered Aug 03 '15 at 11:35

Ramireddy Ambati

199
1
6

stored procedure to return data from multiple tables

2 Answers2