Re: Is this a valid query?

[Chad Ehlers]

To answer your question yes your query is correct. But is it really is the next question.

Select *
From table1 As t1, table2 As t2
Where t1.Id = t2.Id

That will return firstly everything from table1 first, and then everything from table2. Is that really what you want? Just know that t1.id and t2.id are the same number. So you will have duplicate data in there as well.

In my experience anyways most the time you are mostly looking for data from one and some from the next table as well. For instance:

Select u.first_name, u.last_name, ud.address, ud.state
From users As u, users_data As ud
Where u.Id = ud.Users_Id

Hope that helps