Joining SQL Command with Actual Tables

[neozeke]

SQL Command:

select id, max(time) from table1 groupd by id

Table2 fields:
id, name, group

I included the SQL Command in the Crystal Reports using the Database Experts window. I also linked the 2 tables using the ID field (same datatype).

Problem:
When I am populating the fields:
ID, TIME, NAME, and GROUP
There were no records in the report but when I join them in a single SQL, there were records returned.

What could be the problem on this?

Thanks.

 

[lbass]

You should be able to link the command to the table without a problem, although it is inefficient, since the linking will occur locally. What type of join did you use? What did the SQL query look like when you used the single query?

-LB