Jump to content

DB Cross-Referencing


adam84

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/68951-db-cross-referencing/
Share on other sites

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.

Link to comment
https://forums.phpfreaks.com/topic/68951-db-cross-referencing/#findComment-347060
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.