Is it possible to do something like an SQL query within SP Designer workflows?
e.g I want to do something like "SELECT * FROM list-a WHERE client-id = current-clients-id".
or can someone suggest a different way of approaching the problem
Help much appreciated