DB Cross-Referencing

[adam84]

I have two Databases(user, products),

 

1: users(userID, userName) - deals with all the user stuff

2: productInformation (purchaseID, productID, userID )- deals with products and customer purchases

 

What I am trying to do is organize all the products by userName.

 

This is what I have:

SELECT 
               p.purchaseID, p.productID, u.userName
FROM  
               products.productInformation p, user.users u
WHERE
               p.userID = u.userID
ORDER BY  
               u.userName

 

But this doesnt work? any ideas?

[Illusion]

this doesn't work means what? did you got any error?

[fenway]

I'd recommend this instead:

 

SELECT 
               p.purchaseID, p.productID, u.userName
FROM  
               products.productInformation p
JOIN
               user.users u
ON
               p.userID = u.userID
ORDER BY  
               u.userName

 

But it should have worked syntactically both ways.

[liebs19]

Do you have 2 databases or 2 tables?