Hi - working with data that came from an Oracle DB originally. Not sure if the SQL syntax is different, but there this coding that refers to "b". I suspect "b" is an alias (or maybe another query?) but here are the references to "b" I'm seeing. Any thoughts on what it means? Or is it a subset of Table1? Thanks.
Select max(b.date1) from TABLE1 b
where (a.field1 = b.field1 and
a.fieldx = (Select max(b.fieldx) from TABLE1 b
where (a.field1 = b.field1 and
a.field2= b.field2)
Select max(b.date1) from TABLE1 b
where (a.field1 = b.field1 and
a.fieldx = (Select max(b.fieldx) from TABLE1 b
where (a.field1 = b.field1 and
a.field2= b.field2)