Friday 15 July 2011

mysql - Group by + all in ...? -


I want to know that all the added values ​​are in another table.

Example:

  id childId 1 2 1 3 1 4 2 6 2 7 2 8 2 9 childrenIID 2 3 4 6 7 ** Desired Results: ** ID All ChildinInchid1 True 2 False   

Select "Post" P>
  ID when the amount ( Trollfell) = Counting (1) Then from the 'true' and 'false' end (Selection ID, when it is present (choose 1 from the Child ID, where id = Childdid)   < P> When it is present (select ... from ...)   

No comments:

Post a Comment