Dear Friends,

My Name is Eduardo and this is my first post.
I want to make this query, I think It's possible. How I do proceed?

select 
  [dbo].[TestTable].Id,
  [dbo].[TestTable].Name
  (
    select 
      Count(Sub.Id)
    from 
      [dbo].[TestTable] As Sub
    where 
      [dbo].[TestTable].Id = Sub.Id
  ) As 'Count'
from 
  [dbo].[TestTable]

Thanks !

Your query is missing a comma after the second column name

select 
[dbo].[TestTable].Id,
[dbo].[TestTable].Name,
(
select 
Count(Sub.Id)
from 
[dbo].[TestTable] As Sub
where 
[dbo].[TestTable].Id = Sub.Id
) As 'Count'
from 
[dbo].[TestTable]

I assume that TestTable.Id is the PK of the table, in this case the inner select will return a count of one for every row!!

is that what you want?

those kind of queries should be re-written with a join. Those are also more efficient. Subqueries in the selectlist aren't supported at the moment as well, so the join option is the only way to achieve this at the moment.

It was a simple example...

Could you help me to create something like that: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3401&HighLight=1

Obs.: I'm working with SelfService.

Thanks!

Otis wrote:

those kind of queries should be re-written with a join. Those are also more efficient. Subqueries in the selectlist aren't supported at the moment as well, so the join option is the only way to achieve this at the moment.

Could you help me to create something like that: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=3401&HighLight=1

This thread already has a code example of how to create such a query.

Also please refer to the LLBLGen Pro documentation "Using the generated code - SelfServicing - The predicate system" and check the FieldCompareSetPredicate

Good Luck