Is this a valid query

[AdRock]

I have 2 tables (1 for users and 1 for the carshares)

 

I don't have a foreign key but would like to know if this is a valid query becuase i don't have any data in the database yet.

 

I want to select all the fields from the first table and only a few fields from the other table

 

$result = mysql_query("SELECT id, user, seats_available, start_street, start_postcode, start_lat, start_long, end_street, end_postcode, end_lat, end_long,depart_time, user_id, first_name,telephone, email FROM carshare INNER JOIN users ON user.user_id=carshare.user

 

The uers details are from the user table

 

It would be easy to do select * from table1, table2 etc but i don't need all those fields

[fenway]

I would prefix the fields with their respective table [alias] names.