RDA Select statement...

I have attempted to perform the pull operation by using a select statement that references more than one table.... Unfortunately I get an error saying I can't do this....?

I guess I don't understand....I'm pulling full rows from only one table in the statement....I'm only using a join and where clauses to partition the number of rows that are returned. It would seem to me that RDA shouldn't care how I'm requesting the rows...just that I'm asking for entire rows from one table...?

So my select would be something like....

Select Table1.col1, Table1.col2, ...Table1.colx From Table1 Left Outer Join Table2 On Table1.col1=Table2.col3 WHERE Table1.Colx=username

I guess this type of thing can't work with RDA? If it can....how do I go about it?

Thanks

I would be inclined to try a stored procedure or view in SQL Server

For the view this would be:

SELECT col1, col2, col3 from myview where col1=myval1

Brian|||I tried the view...but still no luck with tracking on.