Select values from two tables using loop

Question

I have Two tables named

1.Categortable

Category

Mouse

Computer

Electronics

and the second table Texttable

category                   Text

Mouse                     Logitech Mouse

Computer                  LG Computer

Electronics               LG Electronics

Here I need To select Text for each category in Categortable from Texttable

Can any one help how to loop this to get the output.

sgeddes · Accepted Answer · 2013-05-28 12:27:20Z

4

No need to do any looping here, a simple JOIN should work for you:

SELECT * 
FROM CategoryTable CT
    LEFT JOIN TextTable TT ON CT.Category = TT.Category

I've used a LEFT JOIN in case you want to return rows from your Category table which don't have a corresponding match in the Text table.

In case you only want the matching records, just replace the LEFT JOIN with an INNER JOIN.

A Visual Explanation of SQL Joins

edited May 28, 2013 at 12:27

answered May 28, 2013 at 12:12

sgeddes

62.9k7 gold badges67 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vijay · Accepted Answer · 2013-05-28 12:19:24Z

1

try out this

Select ct.category, tt.Text from Categorytable ct
inner join Texttable tt on ct.category = tt.category

answered May 28, 2013 at 12:19

Vijay

8,47111 gold badges47 silver badges70 bronze badges

Collectives™ on Stack Overflow

Select values from two tables using loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related