Sql 2005
- Thread starter -Luke-
- Start date
do you mean searching within a table?
for example if i am in std_items table and i want to search item apple i can make a new query with
SELECT * FROM TBL_STDITEMS WHERE (FLD_ID = 1)
this will give you as result the first item in the std_item table..
if you are searching an item name you can change the query to something like
SELECT * FROM TBL_STDITEM WHERE (FLD_NAME = 'apple')
this will give you the row details of the item called apple..
is this what you are asking for? in case i can give you all sorts of queries which can be made.
for example if i am in std_items table and i want to search item apple i can make a new query with
SELECT * FROM TBL_STDITEMS WHERE (FLD_ID = 1)
this will give you as result the first item in the std_item table..
if you are searching an item name you can change the query to something like
SELECT * FROM TBL_STDITEM WHERE (FLD_NAME = 'apple')
this will give you the row details of the item called apple..
is this what you are asking for? in case i can give you all sorts of queries which can be made.
Upvote
0