I have a repeater, that populates from a table in the database with a simple select * statement. For example, below I have a table called "Category Table". So in this case the repeater will display three items; Football, Tennis and Golf.
Now what I am trying to do, is display a category name in the repeater only if it is linked to another row in another table. For example, I have another table below called Matches and you can see it has a foreign key called CatID which links it to my Category table.
||Man U v Man City
||Nadal v Feder
||Liverpool V Arsenal
So my repeater should only display; Football and Tennis, and not golf as there are not records in matches that have a catID of 3.
So how can I do this using sql? Is it possible?
Sorry if this seems easy, or if I have not been clear
View Complete Post