In my database table I have two columns : ProdID and Prod. When I query the database to display the IDs and the product names, I would like to make the result a bit more 'User friendly' by changing the column names to 'Product ID and 'Product'. I do this in the following way :
Open query analyser.
Select the required database.
Select ProdID as 'Product ID', Prod as Products from Inventory
No comments:
Post a Comment