You probably want to pick up a good SQL book. MySQL by Paul DuBois is
a really good one.
http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=1090786499/sr=8-2/ref=pd_ka_2/102-0741496-3072118?v=glances=booksn=507846
You want to use the WHERE clause of the select statement.
SELECT table.some_column, table.another_column, ...
FROM table
WHERE some_column = 'some_value'
see the manual:
http://dev.mysql.com/doc/mysql/en/SELECT.html
On Sat, 24 Jul 2004 13:52:53 -0500, Robb Kerr
[EMAIL PROTECTED] wrote:
I have a recordset that retrieves the full content of the table - all
fields, all records. Depending upon the content of different fields in
different tables, I need to display certain fields of certain records
within the full recordset. What's the syntax for selecting a particular
record for display relative to the field contents of another recordset?
Thanx,
--
Robb Kerr
Digital IGUANA
Helping Digital Artists Achieve their Dreams
http://www.digitaliguana.com
http://www.cancerreallysucks.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]