Using multiple tables on FROM with procedure?

Question

This is how my question looks from the SQL procedure, how can I use multiple tables in the FROM ?

ELSE IF @Case = 6 BEGIN
                        SELECT
                        Country,
                        PostalCode,
                        WorkshopId,
                        Comment,
                        Lat,
                        Lng,
                        Box,
                        30km,
                        Installation,
                        WorkShopId_HomeService,
                        WorkSHopId_Installation
                        FROM dbo.tbl_PostalCode AS PC WITH (NOLOCK)

                        WHERE (Country = @Country)

possible duplicate of [SQL SELECT from multiple tables](http://stackoverflow.com/questions/1416003/sql-select-from-multiple-tables) — OzrenTkalcecKrznaric, Aug 14 '13 at 06:23

score 2 · Accepted Answer · answered Aug 14 '13 at 06:23

2

Request you to please study about Joins for getting data from more than 1 table.

Study SQL JOIN Explanation

answered Aug 14 '13 at 06:23

Prahalad Gaggar

11,389
16
53
71

score 0 · Answer 2 · answered Aug 14 '13 at 06:21

0

Use JOINs . Have a loo at this

answered Aug 14 '13 at 06:21

Giannis Paraskevopoulos

18,261
1
49
69

Using multiple tables on FROM with procedure?

2 Answers2