[SOLVED] How I.. select data from merging 2 schemas id table

[sspoke]

I got confused I used to do this before.. but I don't do mysql often so I forgot

 

remember something with  AS statement  im trying to use name='something' from a different schemas to find data X,Y in a different schema I show picture

 

 

I want to get X,Y by name from differnet schema basicaly

 

 

 

 

SELECT x,y FROM user_locations, user_credentials WHERE name='testing123'

SELECT l.x, l.y FROM user_locations AS l , user_credentials AS c WHERE c.name='testing123'

 

 

both show up wrong data

[sspoke]

k i forgot i solved this

 

using

 

SELECT l.x, l.y FROM user_locations AS l, user_credentials AS c WHERE l.id = c.id AND c.name='testing123'

 

 

sorry kk