Statement verifictation

[ddeegan]

hello - I am trying to troubleshoot a data migration project and want to verify a SQL statement.

select pt.field1, ct.address2, ct.contsupref
from child_table ct
join parent_table pt
on ct.accountno=pt.accountno
right join
verify_table vt
on pt.field1=vt.field1
where ct.contact='E-mail address'
and ct.address2 is not null

Is there any way that that address2 and contsupref (from child_table) would not come from the same row in the table?

Sorry if this is a dumb question but I'm having problems finding the cause - hoping to rule this out.

Thanks
Dave

 

[SQLDenis]

No
it will be from the same row unless you use something like MIN(ct.address2), MAX(ct.contsupref)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/