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=glance&s=books&n=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]