abdelelbouhy Posted May 7, 2011 Share Posted May 7, 2011 hello guys if someone can explain this when we create alias we say "select p.product_id from product as p" that is fine but in oscommerce the statement is written like that "select p.product_id from products.p" there's no "AS" so i wonder if both products.p and products AS p are equal Link to comment Share on other sites More sharing options...
birbal Posted May 7, 2011 Share Posted May 7, 2011 here in products.p 'products' refer to the database where table 'p' exist and in p.product p refer to the column product_id od table 'p' .this is not alias. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.