After creating a database in Visual Basic 6. we can write code to allow the user to to search for a certain information using SQL query. SQL stands for Structures Query Language. Using SQL keywords, we are able to select specific information to be displayed based on certain criteria. The syntax of a SQL is as follows:
SELECT fieldname1,fieldname2,…..,fieldnameN FROM TableName
SELECT * FROM TableNam
Learn more about SQL from the link below: