General information
Category:
Coding, syntax & commands
If you posted the table structures as well as the full SELECT statement including the JOIN and WHERE clauses, I'm sure you can get the result you are looking for, if not in one pass then as two consecutive queries. My guess is that you need to add some fields from t2 in the first result set and that an aggregation of the COUNT from the first result set will get you there in a second query.
>Is there something I could add to SELECT to get what I want?
>TIA Mark
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only