aaronjonmartin
Technical User
Ok could somebody tell me if the following is possible and how I could go about achieving it?
I have two querys the first simply returns a column of IDs and another column which is the related names to these IDs. The second query takes an ID (ones from the previous table) and returns the number of times this ID appears in another table (i.e. number of times that ID appears as a value in a foreign key column in another table).
What I want to achieve is to have a datadrid or even simply a repeater which displays this information on one row.
e.g.
Bit of a crude diagram but I hope you get the idea. Basically data from two querys are being displayed in one table. How can I do this?
"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)
I have two querys the first simply returns a column of IDs and another column which is the related names to these IDs. The second query takes an ID (ones from the previous table) and returns the number of times this ID appears in another table (i.e. number of times that ID appears as a value in a foreign key column in another table).
What I want to achieve is to have a datadrid or even simply a repeater which displays this information on one row.
e.g.
Code:
_________________________________________________
| ID | NAME | NumberAppears |
_________________________________________________
| 12 | Aaron | 56 |
Bit of a crude diagram but I hope you get the idea. Basically data from two querys are being displayed in one table. How can I do this?
"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)