tati Posted August 17, 2003 Share Posted August 17, 2003 hi, wondering what the one and two letter combinations in expressions like this mean? m.manufacturers_id, p.products_id, pd.products_name, I guess it is SQL but as i know only the very basics of SQL i'd be very thankful for enlightenment! thanks, tati Link to comment Share on other sites More sharing options...
Guest Posted August 17, 2003 Share Posted August 17, 2003 They are aliases for tables used in the query. If you look further back in the query, you will see something like TABLE_MANUFACTURERS . " m ... This tells it that m.variable name is shorthand for the column from the table manufacturers. Hth, Matt Link to comment Share on other sites More sharing options...
tati Posted August 17, 2003 Author Share Posted August 17, 2003 ah - so if i'm using my own tables and not using them too often i could just as well put in the full tablename like learningvalues.learningv_id etc? or is it advisable to keep the alias syntax for 'selfmade' stuff as well? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.