How can I check to see if row exists in two databases?

I'm not quite sure on the correct way to see if a row exists in both databases. Please help.

@pStoreNum bigint,
@pGuid varchar(100)

IF EXISTS (SELECT Guid FROM dbo.StoreSales WHERE Guid = @pGuid 
AND SELECT Guid F开发者_JAVA技巧ROM dbo.StoreReporting  WHERE Guid = @pGuid)
BEGIN
UPDATE
    dbo.StoreReporting 
SET 
    ValidCount = ValidCount + 1
WHERE
    StoreNum = @pStoreNum
END

---

You just need to specify EXISTS twice:

IF EXISTS (first select) AND EXISTS (second select)
BEGIN
...
END

---

IF EXISTS (SELECT Guid FROM dbo.StoreSales ss
           INNER JOIN dbo.StoreReporting sr
               ON sr.Guid = ss.Guid
           WHERE ss.Guid = @pGuid)

This will check that it's in both tables. The INNER JOIN will limit the result set to rows that have the same GUID in both tables, so if it exists in that JOINed result set it exists both places.