Hi Edwin,
Not so sure I got your question correct. You have data contained in different tables that you want to display and you want to select data from these tables containing a certain string pattern (missing data). This I think means that you are doing joins on your normalized tables and selecting certain fields that you want to display. Next you want to exclude fields that don't have that specific string (missing data). Which is catered for by the previous query. Anyway you could elaborate further or better yet send some code samples or SQL query example.

KR,
Loki

"Excellent people exceed expectations".

From: Edwin Wambua <eddwak@gmail.com>
To: skunkworks@my.co.ke
Sent: Monday, April 6, 2009 1:33:43 PM
Subject: [Skunkworks] PHP searching

Im searchin for specific data in a table which is contained in different rows.i.e.the string "missing data" I need to pull out only the fields that have that string and ignore the rest.Iv managed to display the table in one column with the adjacent field names.Now what's remaining is to exclude the fields that dont have that specific string..Google's not being very useful here.I guess Im asking the wrong questions.