AdRock Posted March 13, 2008 Share Posted March 13, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/95961-is-this-a-valid-query/ Share on other sites More sharing options...
fenway Posted March 13, 2008 Share Posted March 13, 2008 I would prefix the fields with their respective table [alias] names. Quote Link to comment https://forums.phpfreaks.com/topic/95961-is-this-a-valid-query/#findComment-491293 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.